package com.datamation.swadeshi.control.data;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DatabaseHelper extends SQLiteOpenHelper {

	// database information
	public static final String DATABASE_NAME = "swadeshi_database.db";
	public static final int DATABASE_VERSION = 1;
	
	public DatabaseHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}

	/**
	 * ############################ server table Details #################################
	 */
	// table
	public static final String TABLE_SERVER_DB = "serverdb";
	// table attributes
	public static final String SERVER_DB_ID = "server_db_id";
	public static final String SERVER_DB_NAME = "server_db_name";

	private static final String CREATE_SERVER_DB_TABLE = "CREATE TABLE IF NOT EXISTS "
			+ TABLE_SERVER_DB + " (" + SERVER_DB_ID
			+ " INTEGER PRIMARY KEY AUTOINCREMENT, " + SERVER_DB_NAME
			+ " TEXT); ";

	/**
	 * ############################ fDebtor table Details ################################
	 */
	
	// table
	public static final String TABLE_FDEBTOR = "fDebtor";
	// table attributes
	public static final String FDEBTOR_ID = "_id";
	public static final String FDEBTOR_CODE = "DebCode";
	public static final String FDEBTOR_NAME = "DebName";
	public static final String FDEBTOR_ADD1 = "DebAdd1";
	public static final String FDEBTOR_ADD2 = "DebAdd2";
	public static final String FDEBTOR_ADD3 = "DebAdd3";
	public static final String FDEBTOR_TELE = "DebTele";
	public static final String FDEBTOR_MOB = "DebMob";
	public static final String FDEBTOR_EMAIL = "DebEMail";
	public static final String FDEBTOR_CREATEDATE = "CretDate";
	public static final String FDEBTOR_REM_DIS = "RemDis";
	public static final String FDEBTOR_TOWN_CODE = "TownCode";
	public static final String FDEBTOR_AREA_CODE = "AreaCode";
	public static final String FDEBTOR_DEB_CAT_CODE = "DebCatCode";
	public static final String FDEBTOR_DBGR_CODE = "DbGrCode";
	public static final String FDEBTOR_DEB_CLS_CODE = "DebClsCode";
	public static final String FDEBTOR_STATUS = "Status";
	public static final String FDEBTOR_LYLTY = "DebLylty";
	public static final String FDEBTOR_DEAL_CODE = "DealCode";
	public static final String FDEBTOR_ADD_USER = "AddUser";
	public static final String FDEBTOR_ADD_DATE_DEB= "AddDateDEB";
	public static final String FDEBTOR_ADD_MACH = "AddMach";
	public static final String FDEBTOR_RECORD_ID = "RecordId";
	public static final String FDEBTOR_TIME_STAMP = "timestamp_column";
	public static final String FDEBTOR_CRD_PERIOD = "CrdPeriod";
	public static final String FDEBTOR_CHK_CRD_PRD = "ChkCrdPrd";
	public static final String FDEBTOR_CRD_LIMIT = "CrdLimit";
	public static final String FDEBTOR_CHK_CRD_LIMIT = "ChkCrdLmt";
	public static final String FDEBTOR_REP_CODE = "RepCode";
	public static final String FDEBTOR_RANK_CODE = "RankCode";
	public static final String FDEBTOR_TRAN_DATE = "txndate";
	public static final String FDEBTOR_TRAN_BATCH = "TranBatch";
	public static final String FDEBTOR_SUMMARY = "DebSumary";
	public static final String FDEBTOR_OUT_DIS = "OutDis";

	
	//create String 
	private static final String CREATE_FDEBTOR_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FDEBTOR + " (" 
				+ FDEBTOR_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FDEBTOR_CODE+ " TEXT, " 
				+ FDEBTOR_NAME+ " TEXT, " 
				+ FDEBTOR_ADD1+ " TEXT, " 
				+ FDEBTOR_ADD2+ " TEXT, " 
				+ FDEBTOR_ADD3+ " TEXT, " 
				+ FDEBTOR_TELE+ " TEXT, " 
				+ FDEBTOR_MOB+ " TEXT, " 
				+ FDEBTOR_EMAIL+ " TEXT, " 
				+ FDEBTOR_CREATEDATE+ " TEXT, " 
				+ FDEBTOR_REM_DIS+ " TEXT, " 
				+ FDEBTOR_TOWN_CODE+ " TEXT, " 
				+ FDEBTOR_AREA_CODE+ " TEXT, " 
				+ FDEBTOR_DEB_CAT_CODE+ " TEXT, " 
				+ FDEBTOR_DBGR_CODE+ " TEXT, " 
				+ FDEBTOR_DEB_CLS_CODE+ " TEXT, " 
				+ FDEBTOR_STATUS+ " TEXT, " 
				+ FDEBTOR_LYLTY+ " TEXT, " 
				+ FDEBTOR_DEAL_CODE+ " TEXT, " 
				+ FDEBTOR_ADD_USER+ " TEXT, " 
				+ FDEBTOR_ADD_DATE_DEB+ " TEXT, " 
				+ FDEBTOR_ADD_MACH+ " TEXT, " 
				+ FDEBTOR_RECORD_ID+ " TEXT, " 
				+ FDEBTOR_TIME_STAMP+ " TEXT, " 
				+ FDEBTOR_CRD_PERIOD+ " TEXT, " 
				+ FDEBTOR_CHK_CRD_PRD+ " TEXT, " 
				+ FDEBTOR_CRD_LIMIT+ " TEXT, " 
				+ FDEBTOR_CHK_CRD_LIMIT+ " TEXT, " 
				+ FDEBTOR_REP_CODE+ " TEXT, " 
				+ FDEBTOR_RANK_CODE+ " TEXT, " 
				+ FDEBTOR_TRAN_DATE+ " TEXT, " 
				+ FDEBTOR_TRAN_BATCH+ " TEXT, " 
				+ FDEBTOR_OUT_DIS+" TEXT, "
				+ FDEBTOR_SUMMARY+ " TEXT); ";

	/**
	 * ############################ fControl table Details ################################
	 */
	
	// table
	public static final String TABLE_FCONTROL = "fControl";
	// table attributes
	public static final String FCONTROL_ID = "fcontrol_id";
	public static final String FCONTROL_COM_NAME = "ComName";
	public static final String FCONTROL_COM_ADD1 = "ComAdd1";
	public static final String FCONTROL_COM_ADD2 = "ComAdd2";
	public static final String FCONTROL_COM_ADD3 = "ComAdd3";
	public static final String FCONTROL_COM_TEL1 = "comtel1";
	public static final String FCONTROL_COM_TEL2 = "comtel2";
	public static final String FCONTROL_COM_FAX = "comfax1";
	public static final String FCONTROL_COM_EMAIL = "comemail";
	public static final String FCONTROL_COM_WEB = "comweb";
	public static final String FCONTROL_FYEAR = "confyear";
	public static final String FCONTROL_TYEAR = "contyear";
	public static final String FCONTROL_COM_REGNO = "comRegNo";
	public static final String FCONTROL_FTXN = "ConfTxn";
	public static final String FCONTROL_TTXN = "ContTxn";
	public static final String FCONTROL_CRYSTALPATH = "Crystalpath";
	public static final String FCONTROL_VATCMTAXNO = "VatCmTaxNo";
	public static final String FCONTROL_NBTCMTAXNO = "NbtCmTaxNo";
	public static final String FCONTROL_SYSTYPE = "SysType";
	public static final String FCONTROL_DEALCODE = "DealCode";
	public static final String FCONTROL_BASECUR = "basecur";
	public static final String FCONTROL_BALGCRLM = "BalgCrLm";
	public static final String FCONTROL_CONAGE1 = "conage1";
	public static final String FCONTROL_CONAGE2 = "conage2";
	public static final String FCONTROL_CONAGE3 = "conage3";
	public static final String FCONTROL_CONAGE4 = "conage4";
	public static final String FCONTROL_CONAGE5 = "conage5";
	public static final String FCONTROL_CONAGE6 = "conage6";
	public static final String FCONTROL_CONAGE7 = "conage7";
	public static final String FCONTROL_CONAGE8 = "conage8";
	public static final String FCONTROL_CONAGE9 = "conage9";
	public static final String FCONTROL_CONAGE10 = "conage10";
	public static final String FCONTROL_CONAGE11 = "conage11";
	public static final String FCONTROL_CONAGE12 = "conage12";
	public static final String FCONTROL_CONAGE13 = "conage13";
	public static final String FCONTROL_CONAGE14 = "conage14";
	public static final String FCONTROL_SALESACC=  "salesacc";
	
	//create String 
	private static final String CREATE_FCONTROL_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FCONTROL + " (" 
				+ FCONTROL_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FCONTROL_COM_NAME+ " TEXT, " 
				+ FCONTROL_COM_ADD1+ " TEXT, " 
				+ FCONTROL_COM_ADD2+ " TEXT, " 
				+ FCONTROL_COM_ADD3+ " TEXT, " 
				+ FCONTROL_COM_TEL1+ " TEXT, " 
				+ FCONTROL_COM_TEL2+ " TEXT, " 
				+ FCONTROL_COM_FAX+ " TEXT, " 
				+ FCONTROL_COM_EMAIL+ " TEXT, " 
				+ FCONTROL_COM_WEB+ " TEXT, " 
				+ FCONTROL_FYEAR+ " TEXT, " 
				+ FCONTROL_TYEAR+ " TEXT, " 
				+ FCONTROL_COM_REGNO+ " TEXT, " 
				+ FCONTROL_FTXN+ " TEXT, " 
				+ FCONTROL_TTXN+ " TEXT, " 
				+ FCONTROL_CRYSTALPATH+ " TEXT, " 
				+ FCONTROL_VATCMTAXNO+ " TEXT, " 
				+ FCONTROL_NBTCMTAXNO+ " TEXT, " 
				+ FCONTROL_SYSTYPE+ " TEXT, " 
				+ FCONTROL_DEALCODE+ " TEXT, " 
				+ FCONTROL_BASECUR+ " TEXT, " 
				+ FCONTROL_BALGCRLM+ " TEXT, " 
				+ FCONTROL_CONAGE1+ " TEXT, " 
				+ FCONTROL_CONAGE2+ " TEXT, " 
				+ FCONTROL_CONAGE3+ " TEXT, " 
				+ FCONTROL_CONAGE4+ " TEXT, " 
				+ FCONTROL_CONAGE5+ " TEXT, " 
				+ FCONTROL_CONAGE6+ " TEXT, " 
				+ FCONTROL_CONAGE7+ " TEXT, " 
				+ FCONTROL_CONAGE8+ " TEXT, " 
				+ FCONTROL_CONAGE9+ " TEXT, " 
				+ FCONTROL_CONAGE10+ " TEXT, "
				+ FCONTROL_CONAGE11+ " TEXT, " 
				+ FCONTROL_CONAGE12+ " TEXT, " 
				+ FCONTROL_CONAGE13+ " TEXT, " 
				+ FCONTROL_CONAGE14+ " TEXT, "
				+ FCONTROL_SALESACC+ " TEXT); ";

	/**
	 * ############################ fCompanySetting table Details ################################
	 */
	
	// table
	public static final String TABLE_FCOMPANYSETTING = "fCompanySetting";
	// table attributes
	public static final String FCOMPANYSETTING_ID = "fcomset_id";//ok
	public static final String FCOMPANYSETTING_SETTINGS_CODE = "cSettingsCode";//ok
	public static final String FCOMPANYSETTING_GRP = "cSettingGrp";//ok
	public static final String FCOMPANYSETTING_LOCATION_CHAR = "cLocationChar";//ok
	public static final String FCOMPANYSETTING_CHAR_VAL = "cCharVal";//ok
	public static final String FCOMPANYSETTING_NUM_VAL = "nNumVal";//ok
	public static final String FCOMPANYSETTING_REMARKS = "cRemarks";//ok
	public static final String FCOMPANYSETTING_TYPE = "nType";//ok
	//public static final String FCOMPANYSETTING_UPDATEFLAG = "bUpdateFlag";
	public static final String FCOMPANYSETTING_COMPANY_CODE = "cCompanyCode";//ok
	//public static final String FCOMPANYSETTING_RECORD_ID = "recordid";
	//public static final String FCOMPANYSETTING_TIMESTAMP_COLUMN = "timestamp_column";

	
	//create String 
	private static final String CREATE_FCOMPANYSETTING_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FCOMPANYSETTING + " (" 
				+ FCOMPANYSETTING_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FCOMPANYSETTING_SETTINGS_CODE+ " TEXT, " 
				+ FCOMPANYSETTING_GRP+ " TEXT, " 
				+ FCOMPANYSETTING_LOCATION_CHAR+ " TEXT, " 
				+ FCOMPANYSETTING_CHAR_VAL+ " TEXT, " 
				+ FCOMPANYSETTING_NUM_VAL+ " TEXT, " 
				+ FCOMPANYSETTING_REMARKS+ " TEXT, " 
				+ FCOMPANYSETTING_TYPE+ " TEXT, " 
				//+ FCOMPANYSETTING_UPDATEFLAG+ " TEXT, "
				+ FCOMPANYSETTING_COMPANY_CODE+ " TEXT); ";
				//+ FCOMPANYSETTING_RECORD_ID+ " TEXT, " 
				//+ FCOMPANYSETTING_TIMESTAMP_COLUMN+ " TEXT); ";

	
	
//	/**
//	 * ############################ FinvDet table Details ################################
//	 */
//	
//	// table
//	public static final String TABLE_FINVDET = "FinvDet";
//	// table attributes
//	public static final String FINVDET_ID = "invdet_id";
//	public static final String FINVDET_REFNO = "RefNo";
//	public static final String FINVDET_TXNDATE = "TxnDate";
//	public static final String FINVDET_TXNTYPE = "TxnType";
//	public static final String FINVDET_SEQNO = "SeqNo";
//	public static final String FINVDET_ITEMCODE = "Itemcode";
//	public static final String FINVDET_TXNSEQNO = "Txnseqno";
//	public static final String FINVDET_SELLPRICE = "SellPrice";
//	public static final String FINVDET_BSELLPRICE = "BSellPrice";
//	public static final String FINVDET_TSELLPRICE= "TSellPrice";
//	public static final String FINVDET_BTSELLPRICE = "BTSellPrice";
//	public static final String FINVDET_COSTPRICE = "CostPrice";
//	public static final String FINVDET_CASEQTY = "CaseQty";
//	public static final String FINVDET_TYPE = "Type";
//	public static final String FINVDET_PICEQTY = "PiceQty";
//	public static final String FINVDET_QTY = "Qty";
//	public static final String FINVDET_BALQTY = "BalQty";
//	public static final String FINVDET_DISPER = "DisPer";
//	public static final String FINVDET_DISAMT = "DisAmt";
//	public static final String FINVDET_BDISAMT = "BDisAmt";
//	public static final String FINVDET_TAXAMT = "TaxAmt";
//	public static final String FINVDET_BTAXAMT = "BTaxAmt";
//	public static final String FINVDET_AMT = "Amt";
//	public static final String FINVDET_BAMT = "BAmt";
//	public static final String FINVDET_REACODE = "ReaCode";
//	public static final String FINVDET_LINKREC = "Linkrec";
//	public static final String FINVDET_RECORDID = "RecordId";
//	public static final String FINVDET_ITEM_DESCRIPTION = "itemDescription";
//	public static final String FINVDET_REFINVOICEDETNO = "refInvoiceDetNo";
//	public static final String FINVDET_REFINVOICEDETCODE = "refInvoiceDetCode";
//	public static final String FINVDET_REFINVITEMCASEQTY = "refInvitemCaseQty";
//	public static final String FINVDET_REFINVSTOCKORDERNO = "refInvStockOrderNo";
//	public static final String FINVDET_INDETSYNC = "invdetSync";
//	public static final String FINVDET_INDSYSDATE = "invsysdate";
//	public static final String FINVDET_ITEMDISPER = "itemdisper";
//	public static final String FINVDET_ITEMDISPERVAL = "itemdisperval";
//	public static final String FINVDET_REASONCODE = "reasonCode";
//	public static final String FINVDET_REASONDESC = "reasonDesc";
//	public static final String FINVDET_ITEMUNITPRICE = "itemUnitPrice";
//	public static final String FINVDET_CASEP = "caseP";
//	
//	//create String 
//	private static final String CREATE_FINVDET_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FINVDET + " (" 
//				+ FINVDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
//				+ FINVDET_REFNO+ " TEXT, " 
//				+ FINVDET_TXNDATE+ " TEXT, " 
//				+ FINVDET_TXNTYPE+ " TEXT, " 
//				+ FINVDET_SEQNO+ " TEXT, " 
//				+ FINVDET_ITEMCODE+ " TEXT, " 
//				+ FINVDET_TXNSEQNO+ " TEXT, " 
//				+ FINVDET_SELLPRICE+ " TEXT, " 
//				+ FINVDET_BSELLPRICE+ " TEXT, " 
//				+ FINVDET_TSELLPRICE+ " TEXT, " 
//				+ FINVDET_BTSELLPRICE+ " TEXT, " 
//				+ FINVDET_COSTPRICE+ " TEXT, " 
//				+ FINVDET_CASEQTY+ " TEXT, " 
//				+ FINVDET_TYPE+ " TEXT, " 
//				+ FINVDET_PICEQTY+ " TEXT, " 
//				+ FINVDET_QTY+ " TEXT, " 
//				+ FINVDET_BALQTY+ " TEXT, " 
//				+ FINVDET_DISPER+ " TEXT, " 
//				+ FINVDET_DISAMT+ " TEXT, " 
//				+ FINVDET_BDISAMT+ " TEXT, " 
//				+ FINVDET_TAXAMT+ " TEXT, " 
//				+ FINVDET_BTAXAMT+ " TEXT, " 
//				+ FINVDET_AMT+ " TEXT, " 
//				+ FINVDET_BAMT+ " TEXT, " 
//				+ FINVDET_REACODE+ " TEXT, " 
//				+ FINVDET_LINKREC+ " TEXT, " 
//				+ FINVDET_RECORDID+ " TEXT, " 
//				+ FINVDET_ITEM_DESCRIPTION+ " TEXT, " 
//				+ FINVDET_REFINVOICEDETNO+ " TEXT, " 
//				+ FINVDET_REFINVOICEDETCODE+ " TEXT, " 
//				+ FINVDET_REFINVITEMCASEQTY+ " TEXT, " 
//				+ FINVDET_REFINVSTOCKORDERNO+ " TEXT, "
//				+ FINVDET_INDETSYNC+ " TEXT, " 
//				+ FINVDET_INDSYSDATE+ " TEXT, " 
//				+ FINVDET_ITEMDISPER+ " TEXT, " 
//				+ FINVDET_ITEMDISPERVAL+ " TEXT, " 
//				+ FINVDET_REASONCODE+ " TEXT, " 
//				+ FINVDET_REASONDESC+ " TEXT, " 
//				+ FINVDET_ITEMUNITPRICE+ " TEXT, " 
//				+ FINVDET_CASEP+ " TEXT); ";

	/**
	 * ############################ fRoute table Details ################################
	 */
	
	// table
	public static final String TABLE_FROUTE = "fRoute";
	// table attributes
	public static final String FROUTE_ID = "route_id";
	public static final String FROUTE_REPCODE = "RepCode";
	public static final String FROUTE_ROUTECODE = "RouteCode";
	public static final String FROUTE_ROUTE_NAME = "RouteName";
	public static final String FROUTE_RECORDID = "RecordId";
	public static final String FROUTE_ADDDATE = "AddDate";
	public static final String FROUTE_ADD_MACH = "AddMach";
	public static final String FROUTE_ADD_USER = "AddUser";
	public static final String FROUTE_AREACODE = "AreaCode";
	public static final String FROUTE_DEALCODE = "DealCode";
	public static final String FROUTE_FREQNO = "FreqNo";
	public static final String FROUTE_KM = "Km";
	public static final String FROUTE_MINPROCALL = "MinProcall";
	public static final String FROUTE_RDALORATE = "RDAloRate";
	public static final String FROUTE_RDTARGET = "RDTarget";
	public static final String FROUTE_REMARKS = "Remarks";
	public static final String FROUTE_STATUS = "Status";
	public static final String FROUTE_TONNAGE = "Tonnage";


	
	//create String 
	private static final String CREATE_FROUTE_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FROUTE + " (" 
				+ FROUTE_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FROUTE_REPCODE+ " TEXT, " 
				+ FROUTE_ROUTECODE+ " TEXT, " 
				+ FROUTE_ROUTE_NAME+ " TEXT, " 
				+ FROUTE_RECORDID+ " TEXT, " 
				+ FROUTE_ADDDATE+ " TEXT, " 
				+ FROUTE_ADD_MACH+ " TEXT, " 
				+ FROUTE_ADD_USER+ " TEXT, " 
				+ FROUTE_AREACODE+ " TEXT, " 
				+ FROUTE_DEALCODE+ " TEXT, " 
				+ FROUTE_FREQNO+ " TEXT, "
				+ FROUTE_KM+ " TEXT, " 
				+ FROUTE_MINPROCALL+ " TEXT, " 
				+ FROUTE_RDALORATE+ " TEXT, " 
				+ FROUTE_RDTARGET+ " TEXT, "
				+ FROUTE_REMARKS+ " TEXT, " 
				+ FROUTE_STATUS+ " TEXT, " 
				+ FROUTE_TONNAGE+ " TEXT); ";

	
	/**
	 * ############################ fBank table Details ################################
	 */
	
	// table
	public static final String TABLE_FBANK = "fBank";
	// table attributes
	public static final String FBANK_ID = "bankre_id";
	public static final String FBANK_RECORD_ID = "RecordId";
	public static final String FBANK_BANK_CODE = "bankcode";
	public static final String FBANK_BANK_NAME = "bankname";
	public static final String FBANK_BANK_ACC_NO = "bankaccno";
	public static final String FBANK_BRANCH = "Branch";
	public static final String FBANK_ADD1 = "bankadd1";
	public static final String FBANK_ADD2 = "bankadd2";
	public static final String FBANK_ADD_DATE = "AddDate";
	public static final String FBANK_ADD_MACH ="AddMach";
	public static final String FBANK_ADD_USER="AddUser";

	//create String 
	private static final String CREATE_FBANK_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FBANK + " (" 
				+ FBANK_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FBANK_RECORD_ID+ " TEXT, " 
				+ FBANK_BANK_CODE+ " TEXT, " 
				+ FBANK_BANK_NAME+ " TEXT, " 
				+ FBANK_BANK_ACC_NO+ " TEXT, " 
				+ FBANK_BRANCH+ " TEXT, " 
				+ FBANK_ADD1+ " TEXT, " 
				+ FBANK_ADD2+ " TEXT, " 
				+ FBANK_ADD_MACH+ " TEXT, " 
				+ FBANK_ADD_USER+ " TEXT, " 
				+ FBANK_ADD_DATE+ " TEXT); ";

	
	/**
	 * ############################ fReason table Details ################################
	 */
	
	public static final String TABLE_FREASON = "fReason";
	// table attributes
	public static final String FREASON_ID = "freason_id";
	public static final String FREASON_ADD_DATE = "AddDate";
	public static final String FREASON_ADD_MACH = "AddMach";
	public static final String FREASON_ADD_USER = "AddUser";
	public static final String FREASON_CODE = "ReaCode";
	public static final String FREASON_NAME = "ReaName";
	public static final String FREASON_REATCODE = "ReaTcode";
	public static final String FREASON_RECORD_ID = "RecordId";
	public static final String FREASON_TYPE = "Type";


	
	//create String 
	private static final String CREATE_FREASON_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FREASON + " (" 
				+ FREASON_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FREASON_ADD_DATE+ " TEXT, " 
				+ FREASON_ADD_MACH+ " TEXT, " 
				+ FREASON_ADD_USER+ " TEXT, " 
				+ FREASON_CODE+ " TEXT, " 
				+ FREASON_NAME+ " TEXT, " 
				+ FREASON_REATCODE+ " TEXT, " 
				+ FREASON_RECORD_ID+ " TEXT, " 
				+ FREASON_TYPE+ " TEXT); ";

	/**
	 * ############################ fExpense table Details ################################
	 */
	
	// fDebtor table
	public static final String TABLE_FEXPENSE = "fExpense";
	// fDebtor table attributes
	public static final String FEXPENSE_ID = "uexp_id";
	public static final String FEXPENSE_CODE = "ExpCode";
	public static final String FEXPENSE_GRP_CODE = "ExpGrpCode";
	public static final String FEXPENSE_NAME = "ExpName";
	public static final String FEXPENSE_RECORDID = "RecordId";
	public static final String FEXPENSE_STATUS = "Status";
	public static final String FEXPENSE_ADD_MACH = "AddMach";
	public static final String FEXPENSE_ADD_USER = "AddUser";
	public static final String FEXPENSE_ADD_DATE="AddDate";

	
	//create String 
	private static final String CREATE_FEXPENSE_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FEXPENSE + " (" 
				+ FEXPENSE_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FEXPENSE_CODE+ " TEXT, " 
				+ FEXPENSE_GRP_CODE+ " TEXT, " 
				+ FEXPENSE_NAME+ " TEXT, " 
				+ FEXPENSE_RECORDID+ " TEXT, " 
				+ FEXPENSE_STATUS+ " TEXT, " 
				+ FEXPENSE_ADD_MACH+ " TEXT, " 
				+ FEXPENSE_ADD_DATE+ " TEXT, " 
				+ FEXPENSE_ADD_USER+ " TEXT); ";


	/**
	 * ############################ fTown table Details ################################
	 */
	
	// table
	public static final String TABLE_FTOWN = "fTown";
	// table attributes
	public static final String FTOWN_ID = "townre_id";
	public static final String FTOWN_RECORDID = "RecordId";
	public static final String FTOWN_CODE = "TownCode";
	public static final String FTOWN_NAME = "TownName";
	public static final String FTOWN_DISTR_CODE = "DistrCode";
	public static final String FTOWN_ADDDATE = "AddDate";
	public static final String FTOWN_ADD_MACH = "AddMach";
	public static final String FTOWN_ADD_USER = "AddUser";


	
	//create String 
	private static final String CREATE_FTOWN_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FTOWN + " (" 
				+ FTOWN_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FTOWN_RECORDID+ " TEXT, " 
				+ FTOWN_CODE+ " TEXT, " 
				+ FTOWN_NAME+ " TEXT, " 
				+ FTOWN_DISTR_CODE+ " TEXT, " 
				+ FTOWN_ADDDATE+ " TEXT, " 
				+ FTOWN_ADD_MACH+ " TEXT, " 
				+ FTOWN_ADD_USER+ " TEXT); ";

	/**
	 * ############################ FTrgCapUL table Details ################################
	 */
	
	// table
	public static final String TABLE_FTRGCAPUL = "FTrgCapUL";
	// table attributes
	public static final String FTRGCAPUL_ID = "ftrg_id";
	public static final String FTRGCAPUL_ADD_DATE = "AddDate";
	public static final String FTRGCAPUL_ADD_MACH = "AddMach";
	public static final String FTRGCAPUL_ADD_USER = "AddUser";
	public static final String FTRGCAPUL_DEAL_CODE = "DealCode";
	public static final String FTRGCAPUL_MONTH = "Month";
	public static final String FTRGCAPUL_QTY = "Qty";
	public static final String FTRGCAPUL_RECORDID = "RecordId";
	public static final String FTRGCAPUL_REP_CODE = "RepCode";
	public static final String FTRGCAPUL_SKU_CODE = "SKUCode";
	public static final String FTRGCAPUL_YEAR = "Year";

	
	//create String 
	private static final String CREATE_FTRGCAPUL_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FTRGCAPUL + " (" 
				+ FTRGCAPUL_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FTRGCAPUL_ADD_DATE+ " TEXT, " 
				+ FTRGCAPUL_ADD_MACH+ " TEXT, " 
				+ FTRGCAPUL_ADD_USER+ " TEXT, " 
				+ FTRGCAPUL_DEAL_CODE+ " TEXT, " 
				+ FTRGCAPUL_MONTH+ " TEXT, " 
				+ FTRGCAPUL_QTY+ " TEXT, " 
				+ FTRGCAPUL_RECORDID+ " TEXT, " 
				+ FTRGCAPUL_REP_CODE+ " TEXT, " 
				+ FTRGCAPUL_SKU_CODE+ " TEXT, " 
				+ FTRGCAPUL_YEAR+ " TEXT); ";	

	
	/**
	 * ############################ fType table Details ################################
	 */
	
	// table
	public static final String TABLE_FTYPE = "fType";
	// table attributes
	public static final String FTYPE_ID = "ftype_id";
	public static final String FTYPE_ADD_DATE = "AddDate";
	public static final String FTYPE_ADD_MACH = "AddMach";
	public static final String FTYPE_ADD_USER = "AddUser";
	public static final String FTYPE_RECORDID = "RecordId";
	public static final String FTYPE_CODE = "TypeCode";
	public static final String FTYPE_NAME = "TypeName";

	//create String 
	private static final String CREATE_FTYPE_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FTYPE + " (" 
				+ FTYPE_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FTYPE_ADD_DATE+ " TEXT, " 
				+ FTYPE_ADD_MACH+ " TEXT, " 
				+ FTYPE_ADD_USER+ " TEXT, " 
				+ FTYPE_RECORDID+ " TEXT, " 
				+ FTYPE_CODE+ " TEXT, " 
				+ FTYPE_NAME+ " TEXT); ";	
	
	/**
	 * ############################ fSubBrand table Details ################################
	 */
	
	// table
	public static final String TABLE_FSUBBRAND = "fSubBrand";
	// table attributes
	public static final String FSUBBRAND_ID = "fsubbrand_id";
	public static final String FSUBBRAND_ADD_DATE = "AddDate";
	public static final String FSUBBRAND_ADD_MACH = "AddMach";
	public static final String FSUBBRAND_ADD_USER = "AddUser";
	public static final String FSUBBRAND_RECORDID = "RecordId";
	public static final String FSUBBRAND_CODE = "SBrandCode";
	public static final String FSUBBRAND_NAME = "SBrandName";


	
	//create String 
	private static final String CREATE_FSUBBRAND_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FSUBBRAND + " (" 
				+ FSUBBRAND_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FSUBBRAND_ADD_DATE+ " TEXT, " 
				+ FSUBBRAND_ADD_MACH+ " TEXT, " 
				+ FSUBBRAND_ADD_USER+ " TEXT, " 
				+ FSUBBRAND_RECORDID+ " TEXT, " 
				+ FSUBBRAND_CODE+ " TEXT, " 
				+ FSUBBRAND_NAME+ " TEXT); ";	


	/**
	 * ############################ fGroup table Details ################################
	 */
	
	// table
	public static final String TABLE_FGROUP = "fGroup";
	// table attributes
	public static final String FGROUP_ID = "fgroup_id";
	public static final String FGROUP_ADD_DATE = "AddDate";
	public static final String FGROUP_ADD_MACH = "AddMach";
	public static final String FGROUP_ADD_USER = "AddUser";
	public static final String FGROUP_CODE = "GroupCode";
	public static final String FGROUP_NAME = "GroupName";
	public static final String FGROUP_RECORDID = "RecordId";


	
	//create String 
	private static final String CREATE_FGROUP_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FGROUP + " (" 
				+ FGROUP_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FGROUP_ADD_DATE+ " TEXT, " 
				+ FGROUP_ADD_MACH+ " TEXT, " 
				+ FGROUP_ADD_USER+ " TEXT, " 
				+ FGROUP_CODE+ " TEXT, " 
				+ FGROUP_NAME+ " TEXT, " 
				+ FGROUP_RECORDID+ " TEXT); ";		
	
	/**
	 * ############################ fSku table Details ################################
	 */
	
	// table
	public static final String TABLE_FSKU = "fSku";
	// table attributes
	public static final String FSKU_ID = "fsku_id";
	public static final String FSKU_ADD_DATE = "AddDate";
	public static final String FSKU_ADD_MACH = "AddMach";
	public static final String FSKU_ADD_USER = "AddUser";
	public static final String FSKU_BRAND_CODE = "BrandCode";
	public static final String FSKU_GROUP_CODE = "GroupCode";
	public static final String FSKU_ITEM_STATUS = "ItemStatus";
	public static final String FSKU_MUST_SALE = "MustSale";
	public static final String FSKU_NOUCASE = "NOUCase";
	public static final String FSKU_ORDSEQ = "OrdSeq";
	public static final String FSKU_RECORDID = "RecordId";
	public static final String FSKU_SUB_BRAND_CODE = "SBrandCode";
	public static final String FSKU_CODE = "SKUCode";
	public static final String FSKU_NAME = "SkuName";
	public static final String FSKU_SIZE_CODE = "SkuSizCode";
	public static final String FSKU_TONNAGE = "Tonnage";
	public static final String FSKU_TYPE_CODE = "TypeCode";
	public static final String FSKU_UNIT = "Unit";
	


	
	//create String 
	private static final String CREATE_FSKU_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FSKU + " (" 
				+ FSKU_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FSKU_ADD_DATE+ " TEXT, " 
				+ FSKU_ADD_MACH+ " TEXT, " 
				+ FSKU_ADD_USER+ " TEXT, " 
				+ FSKU_BRAND_CODE+ " TEXT, " 
				+ FSKU_GROUP_CODE+ " TEXT, " 
				+ FSKU_ITEM_STATUS+ " TEXT, " 
				+ FSKU_MUST_SALE+ " TEXT, " 
				+ FSKU_NOUCASE+ " TEXT, "
				+ FSKU_ORDSEQ+ " TEXT, " 
				+ FSKU_RECORDID+ " TEXT, " 
				+ FSKU_SUB_BRAND_CODE+ " TEXT, " 
				+ FSKU_CODE+ " TEXT, "
				+ FSKU_NAME+ " TEXT, " 
				+ FSKU_SIZE_CODE+ " TEXT, " 
				+ FSKU_TONNAGE+ " TEXT, " 
				+ FSKU_TYPE_CODE+ " TEXT, " 
				+ FSKU_UNIT+ " TEXT); ";

	/**
	 * ############################ fbrand table Details ################################
	 */
	
	// table
	public static final String TABLE_FBRAND = "fbrand";
	// table attributes
	public static final String FBRAND_ID = "fbrand_id";
	public static final String FBRAND_ADD_MACH = "AddMach";
	public static final String FBRAND_ADD_USER = "AddUser";
	public static final String FBRAND_CODE = "BrandCode";
	public static final String FBRAND_NAME = "BrandName";
	public static final String FBRAND_RECORDID = "RecordId";


	//create String 
	private static final String CREATE_FBRAND_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FBRAND + " (" 
				+ FBRAND_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FBRAND_ADD_MACH+ " TEXT, " 
				+ FBRAND_ADD_USER+ " TEXT, " 
				+ FBRAND_CODE+ " TEXT, " 
				+ FBRAND_NAME+ " TEXT, " 
				+ FBRAND_RECORDID+ " TEXT); ";		



	/**
	 * ############################ FOrdHed table Details ################################
	 */
	
	// table
	public static final String TABLE_FORDHED = "FOrdHed";
	// table attributes
	public static final String FORDHED_ID = "FOrdHed_id";
	public static final String FORDHED_REFNO = "RefNo";
	public static final String FORDHED_ADD_DATE = "AddDate";
	public static final String FORDHED_ADD_MACH = "AddMach";
	public static final String FORDHED_ADD_USER = "AddUser";
	public static final String FORDHED_APP_DATE = "Appdate";
	public static final String FORDHED_APPSTS = "Appsts";
	public static final String FORDHED_APP_USER = "AppUser";
	public static final String FORDHED_BP_TOTAL_DIS = "BPTotalDis";
	public static final String FORDHED_B_TOTAL_AMT = "BTotalAmt";
	public static final String FORDHED_B_TOTAL_DIS = "BTotalDis";
	public static final String FORDHED_B_TOTAL_TAX = "BTotalTax";
	public static final String FORDHED_COST_CODE = "CostCode";
	public static final String FORDHED_CUR_CODE = "CurCode";
	public static final String FORDHED_CUR_RATE = "CurRate";
	public static final String FORDHED_DEB_CODE = "DebCode";
	public static final String FORDHED_DIS_PER = "DisPer";
	public static final String FORDHED_START_TIME_SO = "startTimeSO";
	public static final String FORDHED_END_TIME_SO = "endTimeSO";
	public static final String FORDHED_LONGITUDE = "Longitude";
	public static final String FORDHED_LATITUDE = "Latitude";
	public static final String FORDHED_LOC_CODE = "LocCode";
	public static final String FORDHED_MANU_REF = "ManuRef";
	public static final String FORDHED_RECORD_ID = "RecordId";
	public static final String FORDHED_REMARKS = "Remarks";
	public static final String FORDHED_REPCODE = "RepCode";
	public static final String FORDHED_TAX_REG = "TaxReg";
	public static final String FORDHED_TIMESTAMP_COLUMN = "Timestamp_column";
	public static final String FORDHED_TOTAL_AMT = "TotalAmt";
	public static final String FORDHED_TOTALDIS = "TotalDis";
	public static final String FORDHED_TOTAL_TAX = "TotalTax";
	public static final String FORDHED_TXN_TYPE = "TxnType";
	public static final String FORDHED_TXN_DATE = "TxnDate";
	public static final String FORDHED_ADDRESS = "gpsAddress";
	public static final String FORDHED_TOTAL_ITM_DIS = "TotalItemDis";
	public static final String FORDHED_TOT_MKR_AMT = "TotMkrAmt";
	public static final String FORDHED_IS_SYNCED = "isSynced";
	public static final String FORDHED_IS_ACTIVE = "isActive";
	public static final String FORDHED_DELV_DATE = "DelvDate";
	public static final String FORDHED_HED_DIS_VAL="HedDisVal";
	public static final String FORDHED_HED_DIS_PER_VAL="HedDisPerVal";
	public static final String FORDHED_ROUTE_CODE = "RouteCode";
	public static final String FORDHED_PAYMENT_TYPE = "PaymentType";
	//create String 
	private static final String CREATE_FORDHED_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FORDHED + " (" 
				+ FORDHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FORDHED_ADD_MACH+ " TEXT, " 
				+ FORDHED_ADD_DATE + " TEXT,"
				+ FORDHED_ADD_USER+ " TEXT, " 
				+ FORDHED_APP_DATE+ " TEXT, "
				+ FORDHED_ADDRESS+ " TEXT, "
				+ FORDHED_APPSTS  +" TEXT, "
				+ FORDHED_APP_USER +" TEXT, "
				+ FORDHED_BP_TOTAL_DIS +" TEXT, "
				+ FORDHED_B_TOTAL_AMT +" TEXT, "
				+ FORDHED_B_TOTAL_DIS +" TEXT, "
				+ FORDHED_B_TOTAL_TAX +" TEXT, "
				+ FORDHED_COST_CODE+ " TEXT, " 
				+ FORDHED_CUR_CODE+ " TEXT, " 
				+ FORDHED_CUR_RATE+ " TEXT, " 
				+ FORDHED_DEB_CODE+ " TEXT, " 
				+ FORDHED_LOC_CODE+ " TEXT, " 
				+ FORDHED_MANU_REF+ " TEXT, " 
				+ FORDHED_DIS_PER+ " TEXT, " 
				+ FORDHED_RECORD_ID+ " TEXT, " 
				+ FORDHED_REFNO+ " TEXT, " 
				+ FORDHED_REMARKS+ " TEXT, " 
				+ FORDHED_REPCODE+ " TEXT, " 
				+ FORDHED_TAX_REG+ " TEXT, " 
				+ FORDHED_TIMESTAMP_COLUMN+ " TEXT, " 
				+ FORDHED_TOTAL_TAX+ " TEXT, " 
				+ FORDHED_TOTAL_AMT+ " TEXT, " 
				+ FORDHED_TOTALDIS+ " TEXT, " 
				+ FORDHED_TOTAL_ITM_DIS+ " TEXT, " 
				+ FORDHED_TOT_MKR_AMT + " TEXT, " 
				+ FORDHED_TXN_TYPE+ " TEXT, " 
				+ FORDHED_TXN_DATE + " TEXT, " 
				+ FORDHED_LONGITUDE+ " TEXT, " 
				+ FORDHED_LATITUDE+ " TEXT, " 
				+ FORDHED_START_TIME_SO+ " TEXT, " 
				+ FORDHED_IS_SYNCED+ " TEXT, " 
				+ FORDHED_IS_ACTIVE+ " TEXT, " 
				+ FORDHED_DELV_DATE+ " TEXT, " 
				+ FORDHED_ROUTE_CODE+ " TEXT, "
				+ FORDHED_HED_DIS_VAL+" TEXT, "
				+ FORDHED_HED_DIS_PER_VAL+" TEXT,"
				+ FORDHED_PAYMENT_TYPE+" TEXT,"
				+ FORDHED_END_TIME_SO+ " TEXT); "; 
			
	
	/**
	 * ############################ FOrddet table Details ################################
	 */
	
	// table
	public static final String TABLE_FORDDET = "FOrddet";
	// table attributes
	public static final String FORDDET_ID = "stodet_id";
	public static final String FORDDET_AMT = "Amt";
	public static final String FORDDET_BAL_QTY = "BalQty";
	public static final String FORDDET_B_AMT = "BAmt";
	public static final String FORDDET_B_DIS_AMT = "BDisAmt";
	public static final String FORDDET_BP_DIS_AMT= "BPDisAmt";
	public static final String FORDDET_B_SELL_PRICE = "BSellPrice";
	public static final String FORDDET_BT_TAX_AMT = "BTaxAmt";
	public static final String FORDDET_BT_SELL_PRICE = "BTSellPrice";
	public static final String FORDDET_CASE= "Cases";
	public static final String FORDDET_CASE_QTY = "CaseQty";
	public static final String FORDDET_DIS_AMT = "DisAmt";
	public static final String FORDDET_DIS_PER = "DisPer";
	public static final String FORDDET_FREE_QTY= "freeqty";
	public static final String FORDDET_ITEM_CODE = "Itemcode";
	public static final String FORDDET_P_DIS_AMT = "PDisAmt";
	public static final String FORDDET_PRIL_CODE = "PrilCode";
	public static final String FORDDET_QTY = "Qty";
	public static final String FORDDET_DIS_VAL_AMT = "DisValAmt";
	public static final String FORDDET_PICE_QTY= "PiceQty";
	public static final String FORDDET_REA_CODE = "ReaCode";
	public static final String FORDDET_TYPE = "Types";
	public static final String FORDDET_RECORD_ID = "RecordId";
	public static final String FORDDET_REFNO = "RefNo";
	public static final String FORDDET_SELL_PRICE = "SellPrice";
	public static final String FORDDET_SEQNO = "SeqNo";
	public static final String FORDDET_TAX_AMT = "TaxAmt";
	public static final String FORDDET_TAX_COM_CODE = "TaxComCode";
	public static final String FORDDET_TIMESTAMP_COLUMN = "timestamp_column";
	public static final String FORDDET_T_SELL_PRICE = "TSellPrice";
	public static final String FORDDET_TXN_DATE = "TxnDate";
	public static final String FORDDET_TXN_TYPE = "TxnType";
	public static final String FORDDET_IS_ACTIVE = "isActive";
	//create String 
	private static final String CREATE_FORDDET_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FORDDET + " (" 
				+ FORDDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FORDDET_AMT+ " TEXT, " 
				+ FORDDET_BAL_QTY+ " TEXT, " 
				+ FORDDET_B_AMT+ " TEXT, " 
				+ FORDDET_B_DIS_AMT+ " TEXT, " 
				+ FORDDET_BP_DIS_AMT+ " TEXT, " 
				+ FORDDET_B_SELL_PRICE+ " TEXT, " 
				+ FORDDET_BT_TAX_AMT+ " TEXT, " 
				+ FORDDET_BT_SELL_PRICE+ " TEXT, " 
				+ FORDDET_CASE+ " TEXT, " 
				+ FORDDET_CASE_QTY+ " TEXT, " 
				+ FORDDET_DIS_AMT+ " TEXT, " 
				+ FORDDET_DIS_PER+ " TEXT, " 
				+ FORDDET_FREE_QTY+ " TEXT, " 
				+ FORDDET_ITEM_CODE+ " TEXT, " 
				+ FORDDET_P_DIS_AMT+ " TEXT, " 
				+ FORDDET_PRIL_CODE+ " TEXT, " 
				+ FORDDET_QTY+ " TEXT, " 
				+ FORDDET_DIS_VAL_AMT+ " TEXT, " 
				+ FORDDET_PICE_QTY+ " TEXT, " 
				+ FORDDET_REA_CODE+ " TEXT, " 
				+ FORDDET_TYPE+ " TEXT, " 
				+ FORDDET_RECORD_ID+ " TEXT, " 
				+ FORDDET_REFNO+ " TEXT, " 
				+ FORDDET_SELL_PRICE+ " TEXT, " 
				+ FORDDET_SEQNO+ " TEXT, " 
				+ FORDDET_TAX_AMT+ " TEXT, " 
				+ FORDDET_TAX_COM_CODE+ " TEXT, " 
				+ FORDDET_TIMESTAMP_COLUMN+ " TEXT, " 
				+ FORDDET_T_SELL_PRICE+ " TEXT, " 
				+ FORDDET_TXN_DATE+ " TEXT, " 
				+ FORDDET_IS_ACTIVE+ " TEXT, " 
				+ FORDDET_TXN_TYPE+ " TEXT); ";


	
	/**
	 * ############################ finvHed table Details ################################
	 */
	
	// table
	public static final String TABLE_FINVHED = "finvHed";
	// table attributes
	public static final String FINVHED_ID = "finvHed_id";
	public static final String FINVHED_REFNO = "RefNo";
	public static final String FINVHED_ADD_DATE = "AddDate";
	public static final String FINVHED_ADD_MACH = "AddMach";
	public static final String FINVHED_ADD_USER = "AddUser";
	public static final String FINVHED_APP_DATE = "Appdate";
	public static final String FINVHED_APPSTS = "Appsts";
	public static final String FINVHED_APP_USER = "AppUser";
	public static final String FINVHED_BP_TOTAL_DIS = "BPTotalDis";
	public static final String FINVHED_B_TOTAL_AMT = "BTotalAmt";
	public static final String FINVHED_B_TOTAL_DIS = "BTotalDis";
	public static final String FINVHED_B_TOTAL_TAX = "BTotalTax";
	public static final String FINVHED_COST_CODE = "CostCode";
	public static final String FINVHED_CUR_CODE = "CurCode";
	public static final String FINVHED_CUR_RATE = "CurRate";
	public static final String FINVHED_DEB_CODE = "DebCode";
	public static final String FINVHED_DIS_PER = "DisPer";
	public static final String FINVHED_START_TIME_SO = "startTimeSO";
	public static final String FINVHED_END_TIME_SO = "endTimeSO";
	public static final String FINVHED_LONGITUDE = "Longitude";
	public static final String FINVHED_LATITUDE = "Latitude";
	public static final String FINVHED_LOC_CODE = "LocCode";
	public static final String FINVHED_MANU_REF = "ManuRef";
	public static final String FINVHED_RECORD_ID = "RecordId";
	public static final String FINVHED_REMARKS = "Remarks";
	public static final String FINVHED_REPCODE = "RepCode";
	public static final String FINVHED_TAX_REG = "TaxReg";
	public static final String FINVHED_TIMESTAMP_COLUMN = "Timestamp_column";
	public static final String FINVHED_TOTAL_AMT = "TotalAmt";
	public static final String FINVHED_TOTALDIS = "TotalDis";
	public static final String FINVHED_TOTAL_TAX = "TotalTax";
	public static final String FINVHED_TXN_TYPE = "TxnType";
	public static final String FINVHED_TXN_DATE = "TxnDate";
	public static final String FINVHED_ADDRESS = "gpsAddress";
	public static final String FINVHED_TOTAL_ITM_DIS = "TotalItemDis";
	public static final String FINVHED_TOT_MKR_AMT = "TotMkrAmt";
	public static final String FINVHED_IS_SYNCED = "isSynced";
	public static final String FINVHED_IS_ACTIVE = "isActive";
	public static final String FINVHED_ROUTE_CODE = "RouteCode";
	public static final String FINVHED_REFNO1 = "RefNo1";
	
	public static final String FINVHED_HED_DIS_VAL="HedDisVal";
	public static final String FINVHED_HED_DIS_PER_VAL="HedDisPerVal";
	public static final String FINVHED_PAYMENT_TYPE = "PaymentType";
	
	private static final String CREATE_FINVHED_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FINVHED + " (" 
			+ FINVHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FINVHED_ADD_MACH+ " TEXT, " 
			+ FINVHED_ADD_DATE + " TEXT,"
			+ FINVHED_ADD_USER+ " TEXT, " 
			+ FINVHED_APP_DATE+ " TEXT, "
			+ FINVHED_ADDRESS+ " TEXT, "
			+ FINVHED_APPSTS  +" TEXT, "
			+ FINVHED_APP_USER +" TEXT, "
			+ FINVHED_BP_TOTAL_DIS +" TEXT, "
			+ FINVHED_B_TOTAL_AMT +" TEXT, "
			+ FINVHED_B_TOTAL_DIS +" TEXT, "
			+ FINVHED_B_TOTAL_TAX +" TEXT, "
			+ FINVHED_COST_CODE+ " TEXT, " 
			+ FINVHED_CUR_CODE+ " TEXT, " 
			+ FINVHED_CUR_RATE+ " TEXT, " 
			+ FINVHED_DEB_CODE+ " TEXT, " 
			+ FINVHED_LOC_CODE+ " TEXT, " 
			+ FINVHED_MANU_REF+ " TEXT, " 
			+ FINVHED_DIS_PER+ " TEXT, " 
			+ FINVHED_RECORD_ID+ " TEXT, " 
			+ FINVHED_REFNO+ " TEXT, " 
			+ FINVHED_REMARKS+ " TEXT, " 
			+ FINVHED_REPCODE+ " TEXT, " 
			+ FINVHED_TAX_REG+ " TEXT, " 
			+ FINVHED_TIMESTAMP_COLUMN+ " TEXT, " 
			+ FINVHED_TOTAL_TAX+ " TEXT, " 
			+ FINVHED_TOTAL_AMT+ " TEXT, " 
			+ FINVHED_TOTALDIS+ " TEXT, " 
			+ FINVHED_TOTAL_ITM_DIS+ " TEXT, " 
			+ FINVHED_TOT_MKR_AMT + " TEXT, " 
			+ FINVHED_TXN_TYPE+ " TEXT, " 
			+ FINVHED_TXN_DATE + " TEXT, " 
			+ FINVHED_LONGITUDE+ " TEXT, " 
			+ FINVHED_LATITUDE+ " TEXT, " 
			+ FINVHED_START_TIME_SO+ " TEXT, " 
			+ FINVHED_IS_SYNCED+ " TEXT, " 
			+ FINVHED_IS_ACTIVE+ " TEXT, " 
			+ FINVHED_REFNO1+ " TEXT, " 
			+ FINVHED_ROUTE_CODE+ " TEXT, " 
			+ FINVHED_HED_DIS_VAL+ " TEXT, " 
			+ FINVHED_HED_DIS_PER_VAL+ " TEXT, " 
			+ FINVHED_PAYMENT_TYPE+ " TEXT, " 
			+ FINVHED_END_TIME_SO+ " TEXT); "; 
		

	
	/**
	 * ############################ finvDet table Details ################################
	 */
	
	// table
	public static final String TABLE_FINVDET = "finvDet";
	// table attributes
	public static final String FINVDET_ID = "stodet_id";
	public static final String FINVDET_AMT = "Amt";
	public static final String FINVDET_BAL_QTY = "BalQty";
	public static final String FINVDET_B_AMT = "BAmt";
	public static final String FINVDET_B_DIS_AMT = "BDisAmt";
	public static final String FINVDET_BP_DIS_AMT= "BPDisAmt";
	public static final String FINVDET_B_SELL_PRICE = "BSellPrice";
	public static final String FINVDET_BT_TAX_AMT = "BTaxAmt";
	public static final String FINVDET_BT_SELL_PRICE = "BTSellPrice";
	public static final String FINVDET_CASE= "Cases";
	public static final String FINVDET_CASE_QTY = "CaseQty";
	public static final String FINVDET_DIS_AMT = "DisAmt";
	public static final String FINVDET_DIS_PER = "DisPer";
	public static final String FINVDET_FREE_QTY= "freeqty";
	public static final String FINVDET_ITEM_CODE = "Itemcode";
	public static final String FINVDET_P_DIS_AMT = "PDisAmt";
	public static final String FINVDET_PRIL_CODE = "PrilCode";
	public static final String FINVDET_QTY = "Qty";
	public static final String FINVDET_DIS_VAL_AMT = "DisValAmt";
	public static final String FINVDET_PICE_QTY= "PiceQty";
	public static final String FINVDET_REA_CODE = "ReaCode";
	public static final String FINVDET_TYPE = "Types";
	public static final String FINVDET_RECORD_ID = "RecordId";
	public static final String FINVDET_REFNO = "RefNo";
	public static final String FINVDET_SELL_PRICE = "SellPrice";
	public static final String FINVDET_SEQNO = "SeqNo";
	public static final String FINVDET_TAX_AMT = "TaxAmt";
	public static final String FINVDET_TAX_COM_CODE = "TaxComCode";
	public static final String FINVDET_TIMESTAMP_COLUMN = "timestamp_column";
	public static final String FINVDET_T_SELL_PRICE = "TSellPrice";
	public static final String FINVDET_TXN_DATE = "TxnDate";
	public static final String FINVDET_TXN_TYPE = "TxnType";
	public static final String FINVDET_IS_ACTIVE = "isActive";
	
	private static final String CREATE_FINVDET_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FINVDET + " (" 
			+ FINVDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FINVDET_AMT+ " TEXT, " 
			+ FINVDET_BAL_QTY+ " TEXT, " 
			+ FINVDET_B_AMT+ " TEXT, " 
			+ FINVDET_B_DIS_AMT+ " TEXT, " 
			+ FINVDET_BP_DIS_AMT+ " TEXT, " 
			+ FINVDET_B_SELL_PRICE+ " TEXT, " 
			+ FINVDET_BT_TAX_AMT+ " TEXT, " 
			+ FINVDET_BT_SELL_PRICE+ " TEXT, " 
			+ FINVDET_CASE+ " TEXT, " 
			+ FINVDET_CASE_QTY+ " TEXT, " 
			+ FINVDET_DIS_AMT+ " TEXT, " 
			+ FINVDET_DIS_PER+ " TEXT, " 
			+ FINVDET_FREE_QTY+ " TEXT, " 
			+ FINVDET_ITEM_CODE+ " TEXT, " 
			+ FINVDET_P_DIS_AMT+ " TEXT, " 
			+ FINVDET_PRIL_CODE+ " TEXT, " 
			+ FINVDET_QTY+ " TEXT, " 
			+ FINVDET_DIS_VAL_AMT+ " TEXT, " 
			+ FINVDET_PICE_QTY+ " TEXT, " 
			+ FINVDET_REA_CODE+ " TEXT, " 
			+ FINVDET_TYPE+ " TEXT, " 
			+ FINVDET_RECORD_ID+ " TEXT, " 
			+ FINVDET_REFNO+ " TEXT, " 
			+ FINVDET_SELL_PRICE+ " TEXT, " 
			+ FINVDET_SEQNO+ " TEXT, " 
			+ FINVDET_TAX_AMT+ " TEXT, " 
			+ FINVDET_TAX_COM_CODE+ " TEXT, " 
			+ FINVDET_TIMESTAMP_COLUMN+ " TEXT, " 
			+ FINVDET_T_SELL_PRICE+ " TEXT, " 
			+ FINVDET_TXN_DATE+ " TEXT, " 
			+ FINVDET_IS_ACTIVE+ " TEXT, " 
			+ FINVDET_TXN_TYPE+ " TEXT); ";
	/**
	 * ############################ FCompanyBranch table Details ################################
	 */
	
	// table
	public static final String TABLE_FCOMPANYBRANCH = "FCompanyBranch";
	// table attributes
	public static final String FCOMPANYBRANCH_ID = "fcombra_id";
	public static final String FCOMPANYBRANCH_BRANCH_CODE = "BranchCode";
	public static final String FCOMPANYBRANCH_RECORD_ID = "RecordId";
	public static final String FCOMPANYBRANCH_CSETTINGS_CODE = "cSettingsCode";
	public static final String FCOMPANYBRANCH_NNUM_VAL = "nNumVal";




	
	//create String 
	private static final String CREATE_FCOMPANYBRANCH_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FCOMPANYBRANCH + " (" 
				+ FCOMPANYBRANCH_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FCOMPANYBRANCH_BRANCH_CODE+ " TEXT, " 
				+ FCOMPANYBRANCH_RECORD_ID+ " TEXT, " 
				+ FCOMPANYBRANCH_CSETTINGS_CODE+ " TEXT, " 
				+ FCOMPANYBRANCH_NNUM_VAL+ " TEXT); ";			



	/**
	 * ############################ fSalRep table Details ################################
	 */
	
	// table
	public static final String TABLE_FSALREP = "fSalRep";
	// table attributes
	public static final String FSALREP_ID = "fsalrep_id";
	public static final String FSALREP_ASE_CODE = "ASECode";
	public static final String FSALREP_AREA_CODE = "AreaCode";
	public static final String FSALREP_DEAL_CODE = "DealCode";
	public static final String FSALREP_RECORD_ID = "RecordId";
	public static final String FSALREP_REP_CODE = "RepCode";
	public static final String FSALREP_REP_PREFIX = "RepPrefix";
	public static final String FSALREP_REP_TCODE = "RepTCode";
	public static final String FSALREP_REP_PHONE_NO = "repPhoneNo";
	public static final String FSALREP_REP_NAME = "RepName";
	public static final String FSALREP_REP_EMAIL = "RepEMail";
	public static final String FSALREP_REP_MOB = "RepMob";
	public static final String FSALREP_PASSWORD = "Password";//Password


	
	//create String 
	private static final String CREATE_FSALREP_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FSALREP + " (" 
				+ FSALREP_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FSALREP_ASE_CODE+ " TEXT, " 
				+ FSALREP_AREA_CODE+ " TEXT, " 
				+ FSALREP_DEAL_CODE+ " TEXT, " 
				+ FSALREP_RECORD_ID+ " TEXT, " 
				+ FSALREP_REP_CODE+ " TEXT, " 
				+ FSALREP_REP_PREFIX+ " TEXT, " 
				+ FSALREP_REP_TCODE+ " TEXT, " 
				+ FSALREP_REP_PHONE_NO+ " TEXT, "
				+ FSALREP_REP_NAME+ " TEXT, " 
				+ FSALREP_REP_EMAIL+ " TEXT, "
				+ FSALREP_REP_MOB +" TEXT, "
				+ FSALREP_PASSWORD+ " TEXT); ";

	/**
	 * ############################ FDDbNote table Details ################################
	 */
	
	// table
	public static final String TABLE_FDDBNOTE = "FDDbNote";
	// table attributes
	public static final String FDDBNOTE_ID = "recinv_id";
	public static final String FDDBNOTE_RECORD_ID = "RecordId";
	public static final String FDDBNOTE_REFNO = "RefNo";
	public static final String FDDBNOTE_REF_INV = "RefInv";
	public static final String FDDBNOTE_SALE_REF_NO = "SaleRefNo";
	public static final String FDDBNOTE_MANU_REF = "ManuRef";
	public static final String FDDBNOTE_TXN_TYPE = "TxnType";
	public static final String FDDBNOTE_TXN_DATE = "TxnDate";
	public static final String FDDBNOTE_CUR_CODE = "CurCode";
	public static final String FDDBNOTE_CUR_RATE = "CurRate";
	public static final String FDDBNOTE_DEB_CODE = "DebCode";
	public static final String FDDBNOTE_REP_CODE = "RepCode";
	public static final String FDDBNOTE_TAX_COM_CODE = "TaxComCode";
	public static final String FDDBNOTE_TAX_AMT = "TaxAmt";
	public static final String FDDBNOTE_B_TAX_AMT = "BTaxAmt";
	public static final String FDDBNOTE_AMT = "Amt";
	public static final String FDDBNOTE_B_AMT = "BAmt";
	public static final String FDDBNOTE_TOT_BAL = "TotBal";
	public static final String FDDBNOTE_TOT_BAL1 = "TotBal1";
	public static final String FDDBNOTE_OV_PAY_AMT = "OvPayAmt";
	public static final String FDDBNOTE_REMARKS= "Remarks";
	public static final String FDDBNOTE_CR_ACC = "CrAcc";
	public static final String FDDBNOTE_PRT_COPY = "PrtCopy";
	public static final String FDDBNOTE_GL_POST = "GlPost";
	public static final String FDDBNOTE_GL_BATCH = "glbatch";
	public static final String FDDBNOTE_ADD_USER = "AddUser";
	public static final String FDDBNOTE_ADD_DATE = "AddDate";
	public static final String FDDBNOTE_ADD_MACH = "AddMach";
	public static final String FDDBNOTE_REFNO1 = "RefNo1";

	
	//create String 
	private static final String CREATE_FDDBNOTE_TABLE = "CREATE TABLE IF NOT EXISTS "+ TABLE_FDDBNOTE + " (" 
				+ FDDBNOTE_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FDDBNOTE_RECORD_ID+ " TEXT, " 
				+ FDDBNOTE_REFNO+ " TEXT, " 
				+ FDDBNOTE_REF_INV+ " TEXT, " 
				+ FDDBNOTE_SALE_REF_NO+ " TEXT, " 
				+ FDDBNOTE_MANU_REF+ " TEXT, " 
				+ FDDBNOTE_TXN_TYPE+ " TEXT, " 
				+ FDDBNOTE_TXN_DATE+ " TEXT, " 
				+ FDDBNOTE_CUR_CODE+ " TEXT, " 
				+ FDDBNOTE_CUR_RATE+ " TEXT, " 
				+ FDDBNOTE_DEB_CODE+ " TEXT, " 
				+ FDDBNOTE_REP_CODE+ " TEXT, " 
				+ FDDBNOTE_TAX_COM_CODE+ " TEXT, " 
				+ FDDBNOTE_TAX_AMT+ " TEXT, " 
				+ FDDBNOTE_B_TAX_AMT+ " TEXT, " 
				+ FDDBNOTE_AMT+ " TEXT, " 
				+ FDDBNOTE_B_AMT+ " TEXT, " 
				+ FDDBNOTE_TOT_BAL+ " TEXT, " 
				+ FDDBNOTE_TOT_BAL1+ " TEXT, " 
				+ FDDBNOTE_OV_PAY_AMT+ " TEXT, " 
				+ FDDBNOTE_REMARKS+ " TEXT, " 
				+ FDDBNOTE_CR_ACC+ " TEXT, " 
				+ FDDBNOTE_PRT_COPY+ " TEXT, " 
				+ FDDBNOTE_GL_POST+ " TEXT, " 
				+ FDDBNOTE_GL_BATCH+ " TEXT, " 
				+ FDDBNOTE_ADD_USER+ " TEXT, " 
				+ FDDBNOTE_ADD_DATE+ " TEXT, " 
				+ FDDBNOTE_ADD_MACH+ " TEXT, " 
				+ FDDBNOTE_REFNO1+ " TEXT); ";

	/**
	 * ############################ Ffreedeb table Details ################################
	 */
	
	// table
	public static final String TABLE_FFREEDEB = "Ffreedeb";
	// table attributes
	public static final String FFREEDEB_ID = "Ffreedeb_id";
	public static final String FFREEDEB_REFNO = "Refno";
	public static final String FFREEDEB_DEB_CODE = "Debcode";
	public static final String FFREEDEB_ADD_USER = "AddUser";
	public static final String FFREEDEB_ADD_DATE = "AddDate";
	public static final String FFREEDEB_ADD_MACH = "AddMach";
	public static final String FFREEDEB_RECORD_ID = "RecordId";
	public static final String FFREEDEB_TIMESTAMP_COLUMN = "timestamp_column";
	
	
	//create String 
	private static final String CREATE_FFREEDEB_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FFREEDEB + " (" 
				+ FFREEDEB_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FFREEDEB_REFNO+ " TEXT, " 
				+ FFREEDEB_DEB_CODE+ " TEXT, " 
				+ FFREEDEB_ADD_USER+ " TEXT, " 
				+ FFREEDEB_ADD_DATE+ " TEXT, " 
				+ FFREEDEB_ADD_MACH+ " TEXT, " 
				+ FFREEDEB_RECORD_ID+ " TEXT, " 
				+ FFREEDEB_TIMESTAMP_COLUMN+ " TEXT); ";			
	/**
	 * ############################ Ffreedet table Details ################################
	 */
	
	// table
	public static final String TABLE_FFREEDET = "Ffreedet";
	// table attributes
	public static final String FFREEDET_ID = "Ffreedet_id";
	public static final String FFREEDET_REFNO = "Refno";
	public static final String FFREEDET_ITEM_CODE = "Itemcode";
	public static final String FFREEDET_RECORD_ID = "RecordId";
	
	
	//create String 
	private static final String CREATE_FFREEDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FFREEDET + " (" 
				+ FFREEDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FFREEDET_REFNO+ " TEXT, " 
				+ FFREEDET_ITEM_CODE+ " TEXT, " 
				+ FFREEDET_RECORD_ID+ " TEXT); ";	
	
	

	/**
	 * ############################ Ffreehed table Details ################################
	 */
	
	// table
	public static final String TABLE_FFREEHED = "Ffreehed";
	// table attributes
	public static final String FFREEHED_ID = "Ffreehed_id";
	public static final String FFREEHED_REFNO = "Refno";
	public static final String FFREEHED_TXNDATE = "txndate";
	public static final String FFREEHED_DISC_DESC = "DiscDesc";
	public static final String FFREEHED_PRIORITY = "Priority";
	public static final String FFREEHED_VDATEF = "Vdatef";
	public static final String FFREEHED_VDATET = "Vdatet";
	public static final String FFREEHED_REMARKS = "Remarks";
	public static final String FFREEHED_RECORD_ID = "RecordId";
	public static final String FFREEHED_ITEM_QTY = "ItemQty";
	public static final String FFREEHED_FREE_IT_QTY = "FreeItQty";
	public static final String FFREEHED_FTYPE = "Ftype";


	
	//create String 
	private static final String CREATE_FFREEHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FFREEHED + " (" 
				+ FFREEHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FFREEHED_REFNO+ " TEXT, " 
				+ FFREEHED_TXNDATE+ " TEXT, " 
				+ FFREEHED_DISC_DESC+ " TEXT, " 
				+ FFREEHED_PRIORITY+ " TEXT, " 
				+ FFREEHED_VDATEF+ " TEXT, " 
				+ FFREEHED_VDATET+ " TEXT, " 
				+ FFREEHED_REMARKS+ " TEXT, " 
				+ FFREEHED_RECORD_ID+ " TEXT, "
				+ FFREEHED_ITEM_QTY+ " TEXT, " 
				+ FFREEHED_FREE_IT_QTY+ " TEXT, " 
				+ FFREEHED_FTYPE+ " TEXT); ";

	/**
	* ############################ FfreeSlab table Details ################################
	*/
	
	// table
	public static final String TABLE_FFREESLAB = "Ffreeslab";
	// table attributes
	public static final String FFREESLAB_ID = "Ffreeslab_id";
	public static final String FFREESLAB_REFNO = "Refno";
	public static final String FFREESLAB_QTY_F = "Qtyf";
	public static final String FFREESLAB_QTY_T = "Qtyt";
	public static final String FFREESLAB_FITEM_CODE = "fItemCode";
	public static final String FFREESLAB_FREE_QTY = "freeQty";
	public static final String FFREESLAB_ADD_USER = "AddUser";
	public static final String FFREESLAB_ADD_DATE = "AddDate";
	public static final String FFREESLAB_ADD_MACH = "AddMach";
	public static final String FFREESLAB_RECORD_ID = "RecordId";
	public static final String FFREESLAB_TIMESTAP_COLUMN = "timestamp_column";
	public static final String FFREESLAB_SEQ_NO = "seqno";
	
	//create String 
	private static final String CREATE_FFREESLAB_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FFREESLAB + " (" 
				+ FFREESLAB_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FFREESLAB_REFNO+ " TEXT, " 
				+ FFREESLAB_QTY_F+ " TEXT, " 
				+ FFREESLAB_QTY_T+ " TEXT, " 
				+ FFREESLAB_FITEM_CODE+ " TEXT, " 
				+ FFREESLAB_FREE_QTY+ " TEXT, " 
				+ FFREESLAB_ADD_USER+ " TEXT, " 
				+ FFREESLAB_ADD_DATE+ " TEXT, " 
				+ FFREESLAB_ADD_MACH+ " TEXT, " 
				+ FFREESLAB_RECORD_ID+ " TEXT, " 
				+ FFREESLAB_TIMESTAP_COLUMN+ " TEXT, " 
				+ FFREESLAB_SEQ_NO+ " TEXT); ";	
	
	
	/**
	 * ############################ fFreeItem table Details ################################
	 */
	
	// table
	public static final String TABLE_FFREEITEM = "fFreeItem";
	// table attributes
	public static final String FFREEITEM_ID = "fFreeItem_id";
	public static final String FFREEITEM_REFNO = "Refno";
	public static final String FFREEITEM_ITEMCODE = "Itemcode";
	public static final String FFREEITEM_RECORD_ID = "RecordId";

	
	//create String 
	private static final String CREATE_FFREEITEM_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FFREEITEM + " (" 
				+ FFREEITEM_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FFREEITEM_REFNO+ " TEXT, " 
				+ FFREEITEM_ITEMCODE+ " TEXT, " 
				+ FFREEITEM_RECORD_ID+ " TEXT); ";	
	
	
	/**
	 * ############################ fItem table Details ################################
	 */
	
	// table
	public static final String TABLE_FITEM = "fItem";
	// table attributes
	public static final String FITEM_ID = "fItem_id";
	public static final String FITEM_ADD_MATCH = "AddMach";
	public static final String FITEM_ADD_USER = "AddUser";
	public static final String FITEM_AVG_PRICE = "AvgPrice";
	public static final String FITEM_BRAND_CODE = "BrandCode";
	public static final String FITEM_GROUP_CODE = "GroupCode";
	public static final String FITEM_ITEM_CODE = "ItemCode";
	public static final String FITEM_ITEM_NAME = "ItemName";
	public static final String FITEM_ITEM_STATUS = "ItemStatus";
	public static final String FITEM_MAP_CODE = "MapCode";
	public static final String FITEM_MUST_SALE = "MustSale";
	public static final String FITEM_NOU_CASE = "NOUCase";
	public static final String FITEM_ORD_SEQ = "OrdSeq";
	public static final String FITEM_PRIL_CODE = "PrilCode";
	public static final String FITEM_RE_ORDER_LVL = "ReOrderLvl";
	public static final String FITEM_RE_ORDER_QTY = "ReOrderQty";
	public static final String FITEM_S_BRAND_CODE = "SBrandCode";
	public static final String FITEM_SKU_CODE = "SKUCode";
	public static final String FITEM_SKU_SIZ_CODE = "SkuSizCode";
	public static final String FITEM_TAX_COM_CODE = "TaxComCode";
	public static final String FITEM_TYPE_CODE = "TypeCode";
	public static final String FITEM_UNIT_CODE = "UnitCode";
	public static final String FITEM_VEN_P_CODE = "VenPcode";
	
	//create String 
	private static final String CREATE_FITEM_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FITEM + " (" 
				+ FITEM_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FITEM_ADD_MATCH+ " TEXT, " 
				+ FITEM_ADD_USER+ " TEXT, " 
				+ FITEM_AVG_PRICE+ " TEXT, " 
				+ FITEM_BRAND_CODE+ " TEXT, " 
				+ FITEM_GROUP_CODE+ " TEXT, " 
				+ FITEM_ITEM_CODE+ " TEXT, " 
				+ FITEM_ITEM_NAME+ " TEXT, " 
				+ FITEM_ITEM_STATUS+ " TEXT, " 
				+ FITEM_MAP_CODE+ " TEXT, " 
				+ FITEM_MUST_SALE+ " TEXT, " 
				+ FITEM_NOU_CASE+ " TEXT, " 
				+ FITEM_ORD_SEQ+ " TEXT, " 
				+ FITEM_PRIL_CODE+ " TEXT, " 
				+ FITEM_RE_ORDER_LVL+ " TEXT, " 
				+ FITEM_RE_ORDER_QTY+ " TEXT, " 
				+ FITEM_S_BRAND_CODE+ " TEXT, " 
				+ FITEM_SKU_CODE+ " TEXT, " 
				+ FITEM_SKU_SIZ_CODE+ " TEXT, "
				+ FITEM_TAX_COM_CODE+ " TEXT, " 
				+ FITEM_TYPE_CODE+ " TEXT, " 
				+ FITEM_UNIT_CODE+ " TEXT, " 
				+ FITEM_VEN_P_CODE+ " TEXT); ";	

	/**
	 * ############################ fItemLoc table Details ################################
	 */
	
	// table
	public static final String TABLE_FITEMLOC = "fItemLoc";
	// table attributes
	public static final String FITEMLOC_ID = "fItemLoc_id";
	public static final String FITEMLOC_ITEM_CODE = "ItemCode";
	public static final String FITEMLOC_LOC_CODE = "LocCode";
	public static final String FITEMLOC_QOH = "QOH";
	public static final String FITEMLOC_RECORD_ID = "RecordId";
	
	//create String 
	private static final String CREATE_FITEMLOC_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FITEMLOC + " (" 
				+ FITEMLOC_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FITEMLOC_ITEM_CODE+ " TEXT, " 
				+ FITEMLOC_LOC_CODE+ " TEXT, " 
				+ FITEMLOC_QOH+ " TEXT, " 
				+ FITEMLOC_RECORD_ID+ " TEXT); ";	


	/**
	 * ############################ fItemPri table Details ################################
	 */
		// table
		public static final String TABLE_FITEMPRI = "fItemPri";
		// table attributes
		public static final String FITEMPRI_ID = "fItemPri_id";
		public static final String FITEMPRI_ADD_MACH = "AddMach";
		public static final String FITEMPRI_ADD_USER = "AddUser";
		public static final String FITEMPRI_ITEM_CODE = "ItemCode";
		public static final String FITEMPRI_PRICE = "Price";
		public static final String FITEMPRI_PRIL_CODE = "PrilCode";
		public static final String FITEMPRI_SKU_CODE = "SKUCode";
		public static final String FITEMPRI_TXN_MACH = "TxnMach";
		public static final String FITEMPRI_TXN_USER = "Txnuser";
		
		//create String 
		private static final String CREATE_FITEMPRI_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FITEMPRI + " (" 
					+ FITEMPRI_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FITEMPRI_ADD_MACH+ " TEXT, " 
					+ FITEMPRI_ADD_USER+ " TEXT, " 
					+ FITEMPRI_ITEM_CODE+ " TEXT, " 
					+ FITEMPRI_PRICE+ " TEXT, " 
					+ FITEMPRI_PRIL_CODE+ " TEXT, " 
					+ FITEMPRI_SKU_CODE+ " TEXT, " 
					+ FITEMPRI_TXN_MACH+ " TEXT, " 
					+ FITEMPRI_TXN_USER+ " TEXT); ";	
	
		/**
		 * ############################ fArea table Details ################################
		 */
			// table
			public static final String TABLE_FAREA = "fArea";
			// table attributes
			public static final String FAREA_ID = "fArea_id";
			public static final String FAREA_ADD_MACH = "AddMach";
			public static final String FAREA_ADD_USER = "AddUser";
			public static final String FAREA_AREA_CODE = "AreaCode";
			public static final String FAREA_AREA_NAME = "AreaName";
			public static final String FAREA_DEAL_CODE = "DealCode";
			public static final String FAREA_REQ_CODE = "RegCode";

			
			//create String 
			private static final String CREATE_FAREA_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FAREA + " (" 
						+ FAREA_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
						+ FAREA_ADD_MACH+ " TEXT, " 
						+ FAREA_ADD_USER+ " TEXT, " 
						+ FAREA_AREA_CODE+ " TEXT, " 
						+ FAREA_AREA_NAME+ " TEXT, " 
						+ FAREA_DEAL_CODE+ " TEXT, " 
						+ FAREA_REQ_CODE+ " TEXT); ";
		/**
		 * ############################ fLocations table Details ################################
		 */
			// table
			public static final String TABLE_FLOCATIONS = "fLocations";
			// table attributes
			public static final String FLOCATIONS_ID = "fLocations_id";
			public static final String FLOCATIONS_ADD_MACH = "AddMach";
			public static final String FLOCATIONS_ADD_USER = "AddUser";
			public static final String FLOCATIONS_LOC_CODE = "LocCode";
			public static final String FLOCATIONS_LOC_NAME = "LocName";
			public static final String FLOCATIONS_LOC_T_CODE = "LoctCode";
			public static final String FLOCATIONS_REP_CODE = "RepCode";

				
			//create String 
			private static final String CREATE_FLOCATIONS_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FLOCATIONS + " (" 
						+ FLOCATIONS_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
						+ FLOCATIONS_ADD_MACH+ " TEXT, " 
						+ FLOCATIONS_ADD_USER+ " TEXT, " 
						+ FLOCATIONS_LOC_CODE+ " TEXT, " 
						+ FLOCATIONS_LOC_NAME+ " TEXT, " 
						+ FLOCATIONS_LOC_T_CODE+ " TEXT, " 
						+ FLOCATIONS_REP_CODE+ " TEXT); ";	
		/**
		 * ############################ fDealer table Details ################################
		*/
		// table
		public static final String TABLE_FDEALER = "fDealer";
		// table attributes
		public static final String FDEALER_ID = "fDealer_id";
		public static final String FDEALER_ADD_DATE = "AddDate";
		public static final String FDEALER_ADD_MACH = "AddMach";
		public static final String FDEALER_ADD_USER = "AddUser";
		public static final String FDEALER_CUS_TYP_CODE = "CusTypCode";
		public static final String FDEALER_DEAL_ADD1 = "DealAdd1";
		public static final String FDEALER_DEAL_ADD2 = "DealAdd2";
		public static final String FDEALER_DEAL_ADD3 = "DealAdd3";
		public static final String FDEALER_DEAL_CODE = "DealCode";
		public static final String FDEALER_DEAL_EMAIL = "DealEMail";
		public static final String FDEALER_DEAL_GD_CODE = "DealGdCode";
		public static final String FDEALER_DEAL_MOB = "DealMob";
		public static final String FDEALER_DEAL_NAME = "DealName";
		public static final String FDEALER_DEAL_TELE = "DealTele";
		public static final String FDEALER_DISTANCE = "Distance";
		public static final String FDEALER_STATUS = "Status";
		public static final String FDEALER_PREFIX = "DealPreFix";
		//create String 
		private static final String CREATE_FDEALER_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDEALER + " (" 
			+ FDEALER_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDEALER_ADD_DATE+ " TEXT, " 
			+ FDEALER_ADD_MACH+ " TEXT, " 
			+ FDEALER_ADD_USER+ " TEXT, " 
			+ FDEALER_CUS_TYP_CODE+ " TEXT, " 
			+ FDEALER_DEAL_ADD1+ " TEXT, " 
			+ FDEALER_DEAL_ADD2+ " TEXT, " 
			+ FDEALER_DEAL_ADD3+ " TEXT, " 
			+ FDEALER_DEAL_CODE+ " TEXT, " 
			+ FDEALER_DEAL_EMAIL+ " TEXT, " 
			+ FDEALER_DEAL_GD_CODE+ " TEXT, " 
			+ FDEALER_DEAL_MOB+ " TEXT, " 
			+ FDEALER_DEAL_NAME+ " TEXT, " 
			+ FDEALER_DEAL_TELE+ " TEXT, " 
			+ FDEALER_DISTANCE+ " TEXT, " 
			+ FDEALER_STATUS+ " TEXT,"
			+ FDEALER_PREFIX+ " TEXT); ";	
				
		/**
		 * ############################ fMerch table Details ################################
		*/
		// table
		public static final String TABLE_FMERCH = "fMerch";
		// table attributes
		public static final String FMERCH_ID = "fMerch_id";
		public static final String FMERCH_CODE = "MerchCode";
		public static final String FMERCH_NAME = "MerchName";
		public static final String FMERCH_ADD_USER = "AddUser";
		public static final String FMERCH_ADD_DATE = "AddDate";
		public static final String FMERCH_ADD_MACH = "AddMach";
		public static final String FMERCH_RECORD_ID = "RecordId";
		public static final String FMERCH_TIMESTAMP_COLUMN = "timestamp_column";
		
		//create String 
		private static final String CREATE_FMERCH_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FMERCH + " (" 
			+ FMERCH_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FMERCH_CODE+ " TEXT, " 
			+ FMERCH_NAME+ " TEXT, " 
			+ FMERCH_ADD_USER+ " TEXT, " 
			+ FMERCH_ADD_DATE+ " TEXT, " 
			+ FMERCH_ADD_MACH+ " TEXT, " 
			+ FMERCH_RECORD_ID+ " TEXT, " 
			+ FMERCH_TIMESTAMP_COLUMN+ " TEXT); ";
		
		/**
		 * ############################ FfreeMslab table Details ################################
		*/
		// table
		public static final String TABLE_FFREEMSLAB = "FfreeMslab";
		// table attributes
		public static final String FFREEMSLAB_ID = "FfreeMslab_id";
		public static final String FFREEMSLAB_REFNO = "Refno";
		public static final String FFREEMSLAB_QTY_F = "Qtyf";
		public static final String FFREEMSLAB_QTY_T = "Qtyt";
		public static final String FFREEMSLAB_ITEM_QTY = "ItemQty";
		public static final String FFREEMSLAB_FREE_IT_QTY = "FreeItQty";
		public static final String FFREEMSLAB_ADD_USER = "AddUser";
		public static final String FFREEMSLAB_ADD_DATE = "AddDate";
		public static final String FFREEMSLAB_ADD_MACH = "AddMach";
		public static final String FFREEMSLAB_RECORD_ID = "RecordId";
		public static final String FFREEMSLAB_TIMESTAMP_COLUMN = "timestamp_column";
		public static final String FFREEMSLAB_SEQ_NO = "seqno";

		//create String 
		private static final String CREATE_FFREEMSLAB_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FFREEMSLAB + " (" 
			+ FFREEMSLAB_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FFREEMSLAB_REFNO+ " TEXT, " 
			+ FFREEMSLAB_QTY_F+ " TEXT, " 
			+ FFREEMSLAB_QTY_T+ " TEXT, " 
			+ FFREEMSLAB_ITEM_QTY+ " TEXT, " 
			+ FFREEMSLAB_FREE_IT_QTY+ " TEXT, " 
			+ FFREEMSLAB_ADD_USER+ " TEXT, " 
			+ FFREEMSLAB_ADD_DATE+ " TEXT, " 
			+ FFREEMSLAB_ADD_MACH+ " TEXT, " 
			+ FFREEMSLAB_RECORD_ID+ " TEXT, " 
			+ FFREEMSLAB_TIMESTAMP_COLUMN+ " TEXT, " 
			+ FFREEMSLAB_SEQ_NO+ " TEXT); ";	
		
		/**
		 * ############################ fRouteDet table Details ################################
		 */
			// table
			public static final String TABLE_FROUTEDET = "fRouteDet";
			// table attributes
			public static final String FROUTEDET_ID = "fRouteDet_id";
			public static final String FROUTEDET_DEB_CODE = "DebCode";
			public static final String FROUTEDET_ROUTE_CODE = "RouteCode";

			
			//create String 
			private static final String CREATE_FROUTEDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FROUTEDET + " (" 
						+ FROUTEDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
						+ FROUTEDET_DEB_CODE+ " TEXT, " 
						+ FROUTEDET_ROUTE_CODE+ " TEXT); ";
			
			/**
			 * ############################ FDiscvhed table Details ################################
			*/
			// table
			public static final String TABLE_FDISCVHED = "FDiscvhed";
			// table attributes
			public static final String FDISCVHED_ID = "FDiscvhed_id";
			public static final String FDISCVHED_REF_NO = "Refno";
			public static final String FDISCVHED_TXN_DATE = "Txndate";
			public static final String FDISCVHED_DISC_DESC = "DiscDesc";
			public static final String FDISCVHED_PRIORITY = "Priority";
			public static final String FDISCVHED_DIS_TYPE = "DisType";
			public static final String FDISCVHED_V_DATE_F = "Vdatef";
			public static final String FDISCVHED_V_DATE_T = "Vdatet";
			public static final String FDISCVHED_REMARKS = "Remarks";

			//create String 
			private static final String CREATE_FDISCVHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCVHED + " (" 
				+ FDISCVHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FDISCVHED_REF_NO+ " TEXT, " 
				+ FDISCVHED_TXN_DATE+ " TEXT, " 
				+ FDISCVHED_DISC_DESC+ " TEXT, " 
				+ FDISCVHED_PRIORITY+ " TEXT, " 
				+ FDISCVHED_DIS_TYPE+ " TEXT, " 
				+ FDISCVHED_V_DATE_F+ " TEXT, " 
				+ FDISCVHED_V_DATE_T+ " TEXT, " 
				+ FDISCVHED_REMARKS+ " TEXT); ";	
		/**
		 * ############################ Fdiscvdet table Details ################################
		*/
		// table
		public static final String TABLE_FDISCVDET = "Fdiscvdet";
		// table attributes
		public static final String FDISCVDET_ID = "FDiscvdet_id";
		public static final String FDISCVDET_REF_NO = "Refno";
		public static final String FDISCVDET_VALUE_F = "Valuef";
		public static final String FDISCVDET_VALUE_T = "Valuet";
		public static final String FDISCVDET_DISPER = "Disper";
		public static final String FDISCVDET_DIS_AMT = "Disamt";

		//create String 
		private static final String CREATE_FDISCVDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCVDET + " (" 
			+ FDISCVDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDISCVDET_REF_NO+ " TEXT, " 
			+ FDISCVDET_VALUE_F+ " TEXT, " 
			+ FDISCVDET_VALUE_T+ " TEXT, " 
			+ FDISCVDET_DISPER+ " TEXT, " 
			+ FDISCVDET_DIS_AMT+ " TEXT); ";
		
		/**
		 * ############################ FDiscvdeb table Details ################################
		*/
		// table
		public static final String TABLE_FDISCVDEB = "FDiscvdeb";
		// table attributes
		public static final String FDISCVDEB_ID = "FDiscvdet_id";
		public static final String FDISCVDEB_REF_NO = "Refno";
		public static final String FDISCVDED_DEB_CODE = "Debcode";


		//create String 
		private static final String CREATE_FDISCVDEB_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCVDEB + " (" 
			+ FDISCVDEB_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDISCVDEB_REF_NO+ " TEXT, " 
			+ FDISCVDED_DEB_CODE+ " TEXT); ";
	
		
		
		/**
		 * ############################ fdisched table Details ################################
		*/
		// table
		public static final String TABLE_FDISCHED = "fdisched";
		// table attributes
		public static final String FDISCHED_ID = "fdisched_id";
		public static final String FDISCHED_REF_NO = "RefNo";
		public static final String FDISCHED_TXN_DATE = "TxnDate";
		public static final String FDISCHED_DISC_DESC = "DiscDesc";
		public static final String FDISCHED_PRIORITY = "Priority";
		public static final String FDISCHED_DIS_TYPE = "DisType";
		public static final String FDISCHED_V_DATE_F = "Vdatef";
		public static final String FDISCHED_V_DATE_T = "Vdatet";
		public static final String FDISCHED_REMARK = "Remarks";
		public static final String FDISCHED_ADD_USER = "AddUser";
		public static final String FDISCHED_ADD_DATE = "AddDate";	
		public static final String FDISCHED_ADD_MACH = "AddMach";
		public static final String FDISCHED_RECORD_ID = "RecordId";
		public static final String FDISCHED_TIMESTAMP_COLUMN = "timestamp_column";
		//create String 
		private static final String CREATE_FDISCHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCHED + " (" 
			+ FDISCHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDISCHED_REF_NO+ " TEXT, " 
			+ FDISCHED_TXN_DATE+ " TEXT, " 
			+ FDISCHED_DISC_DESC+ " TEXT, " 
			+ FDISCHED_PRIORITY+ " TEXT, "
			+ FDISCHED_DIS_TYPE+ " TEXT, " 
			+ FDISCHED_V_DATE_F+ " TEXT, "
			+ FDISCHED_V_DATE_T+ " TEXT, "
			+ FDISCHED_REMARK+ " TEXT, " 
			+ FDISCHED_ADD_USER+ " TEXT, " 
			+ FDISCHED_ADD_DATE+ " TEXT, " 
			+ FDISCHED_ADD_MACH+ " TEXT, " 
			+ FDISCHED_RECORD_ID+ " TEXT, " 
			+ FDISCHED_TIMESTAMP_COLUMN+ " TEXT); ";
	
		
		/**
		 * ############################ FDiscdet table Details ################################
		*/
		
		// table
		public static final String TABLE_FDISCDET = "FDiscdet";
		// table attributes
		public static final String FDISCDET_ID = "FDiscdet_id";
		public static final String FDISCDET_REF_NO = "RefNo";
		public static final String FDISCDET_ITEM_CODE = "itemcode";
		public static final String FDISCDET_RECORD_ID = "RecordId";
		public static final String FDISCHED_TIEMSTAMP_COLUMN = "timestamp_column";
		
		//create String 
		private static final String CREATE_FDISCDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCDET + " (" 
			+ FDISCDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDISCDET_REF_NO+ " TEXT, " 
			+ FDISCDET_ITEM_CODE+ " TEXT, " 
			+ FDISCDET_RECORD_ID+ " TEXT, " 
			+ FDISCHED_TIEMSTAMP_COLUMN+ " TEXT); ";
		
		/**
		 * ############################ FDiscdeb table Details ################################ 
		*/
		
		// table
		public static final String TABLE_FDISCDEB = "FDiscdeb";
		// table attributes
		public static final String FDISCDEB_ID = "FDiscdet_id";
		public static final String FDISCDEB_REF_NO = "RefNo";
		public static final String FDISCDEB_DEB_CODE = "debcode";
		public static final String FDISCDEB_RECORD_ID = "RecordId";
		public static final String FDISCDEB_TIEMSTAMP_COLUMN = "timestamp_column";
		
		//create String 
		private static final String CREATE_FDISCDEB_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCDEB + " (" 
			+ FDISCDEB_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDISCDEB_REF_NO+ " TEXT, " 
			+ FDISCDEB_DEB_CODE+ " TEXT, " 
			+ FDISCDET_RECORD_ID+ " TEXT, " 
			+ FDISCHED_TIEMSTAMP_COLUMN+ " TEXT); ";	
		
		/**
		 * ############################ FDiscslab table Details ################################ 
		*/
		
		// table
		public static final String TABLE_FDISCSLAB = "FDiscslab";
		// table attributes
		public static final String FDISCSLAB_ID = "FDiscdet_id";
		public static final String FDISCSLAB_REF_NO = "RefNo";
		public static final String FDISCSLAB_SEQ_NO = "seqno";
		public static final String FDISCSLAB_QTY_F = "Qtyf";
		public static final String FDISCSLAB_QTY_T = "Qtyt";
		public static final String FDISCSLAB_DIS_PER = "disper";
		public static final String FDISCSLAB_DIS_AMUT = "disamt";
		public static final String FDISCSLAB_RECORD_ID = "RecordId";
		public static final String FDISCSLAB_TIMESTAMP_COLUMN = "timestamp_column";
	
		
		//create String 
		private static final String CREATE_FDISCSLAB_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDISCSLAB + " (" 
			+ FDISCSLAB_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FDISCSLAB_REF_NO+ " TEXT, " 
			+ FDISCSLAB_SEQ_NO+ " TEXT, " 
			+ FDISCSLAB_QTY_F+ " TEXT, " 
			+ FDISCSLAB_QTY_T+ " TEXT, " 
			+ FDISCSLAB_DIS_PER+ " TEXT, " 
			+ FDISCSLAB_DIS_AMUT+ " TEXT, " 
			+ FDISCSLAB_RECORD_ID+ " TEXT, " 
			+ FDISCSLAB_TIMESTAMP_COLUMN+ " TEXT); ";
		
		/**
		 * ############################ FItenrHed table Details ################################ 
		*/
		
		// table
		public static final String TABLE_FITENRHED = "FItenrHed";
		// table attributes
		public static final String FITENRHED_ID = "FItenrHed_id";
		public static final String FITENRHED_COST_CODE = "CostCode";
		public static final String FITENRHED_DEAL_CODE = "DealCode";
		public static final String FITENRHED_MONTH = "Month";
		public static final String FITENRHED_REF_NO = "RefNo";
		public static final String FITENRHED_REMARKS1 = "Remarks1";
		public static final String FITENRHED_REP_CODE = "RepCode";
		public static final String FITENRHED_YEAR = "Year";
		
	
		
		//create String 
		private static final String CREATE_FITENRHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FITENRHED + " (" 
			+ FITENRHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FITENRHED_COST_CODE+ " TEXT, " 
			+ FITENRHED_DEAL_CODE+ " TEXT, " 
			+ FITENRHED_MONTH+ " TEXT, " 
			+ FITENRHED_REF_NO+ " TEXT, " 
			+ FITENRHED_REMARKS1+ " TEXT, " 
			+ FITENRHED_REP_CODE+ " TEXT, " 
			+ FITENRHED_YEAR+ " TEXT); ";

		/**
		 * ############################ FItenrDet table Details ################################ 
		*/
		
		// table
		public static final String TABLE_FITENRDET = "FItenrDet";
		// table attributes
		public static final String FITENRDET_ID = "FItenrDet_id";
		public static final String FITENRDET_NO_OUTLET = "NoOutlet";
		public static final String FITENRDET_NO_SHCUCAL = "NoShcuCal";
		public static final String FITENRDET_RD_TARGET = "RDTarget";
		public static final String FITENRDET_REF_NO = "RefNo";
		public static final String FITENRDET_REMARKS = "Remarks";
		public static final String FITENRDET_ROUTE_CODE = "RouteCode";
		public static final String FITENRDET_TXN_DATE = "TxnDate";
		
	
		
		//create String 
		private static final String CREATE_FITENRDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FITENRDET + " (" 
			+ FITENRDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FITENRDET_NO_OUTLET+ " TEXT, " 
			+ FITENRDET_NO_SHCUCAL+ " TEXT, " 
			+ FITENRDET_RD_TARGET+ " TEXT, " 
			+ FITENRDET_REF_NO+ " TEXT, " 
			+ FITENRDET_REMARKS+ " TEXT, " 
			+ FITENRDET_ROUTE_CODE+ " TEXT, " 
			+ FITENRDET_TXN_DATE+ " TEXT); ";
	/**
	 * ############################ FIteDebDet table Details ################################ 
	*/
		
		// table
		public static final String TABLE_FITEDEBDET = "FIteDebDet";
		// table attributes
		public static final String FITEDEBDET_ID = "FItenrDet_id";
		public static final String FITEDEBDET_DEB_CODE = "DebCode";
		public static final String FITEDEBDET_REF_NO = "RefNo";
		public static final String FITEDEBDET_ROUTE_CODE = "RouteCode";
		public static final String FITEDEBDET_TXN_DATE = "TxnDate";
		
			
		//create String 
		private static final String CREATE_FITEDEBDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FITEDEBDET + " (" 
			+ FITEDEBDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
			+ FITEDEBDET_DEB_CODE+ " TEXT, " 
			+ FITEDEBDET_REF_NO+ " TEXT, " 
			+ FITEDEBDET_ROUTE_CODE+ " TEXT, " 
			+ FITEDEBDET_TXN_DATE+ " TEXT); ";

		/**
		 * ############################ FinvHedL3  table Details ################################ 
		*/
			
			// table
			public static final String TABLE_FINVHEDL3 = "FinvHedL3";
			// table attributes
			public static final String FINVHEDL3_ID = "FinvHedL3_id";
			public static final String FINVHEDL3_DEB_CODE = "DebCode";
			public static final String FINVHEDL3_REF_NO = "RefNo";
			public static final String FINVHEDL3_REF_NO1 = "RefNo1";
			public static final String FINVHEDL3_TOTAL_AMT = "TotalAmt";
			public static final String FINVHEDL3_TOTAL_TAX = "TotalTax";
			public static final String FINVHEDL3_TXN_DATE = "TxnDate";
			
			//create String 
			private static final String CREATE_FINVHEDL3_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FINVHEDL3 + " (" 
				+ FINVHEDL3_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
				+ FINVHEDL3_DEB_CODE+ " TEXT, " 
				+ FINVHEDL3_REF_NO+ " TEXT, " 
				+ FINVHEDL3_REF_NO1+ " TEXT, " 
				+ FINVHEDL3_TOTAL_AMT+ " TEXT, " 
				+ FINVHEDL3_TOTAL_TAX+ " TEXT, " 
				+ FINVHEDL3_TXN_DATE+ " TEXT); ";
			
			/**
			 * ############################ FinvHedL3  table Details ################################ 
			*/
				
				// table
				public static final String TABLE_FINVDETL3 = "FinvDetL3";
				// table attributes
				public static final String FINVDETL3_ID = "FinvDetL3_id";
				public static final String FINVDETL3_AMT = "Amt";
				public static final String FINVDETL3_ITEM_CODE = "ItemCode";
				public static final String FINVDETL3_QTY = "Qty";
				public static final String FINVDETL3_REF_NO = "RefNo";
				public static final String FINVDETL3_SEQ_NO = "SeqNo";
				public static final String FINVDETL3_TAX_AMT = "TaxAmt";
				public static final String FINVDETL3_TAX_COM_CODE = "TaxComCode";
				public static final String FINVDETL3_TXN_DATE = "TxnDate";
				
				//create String 
				private static final String CREATE_FINVDETL3_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FINVDETL3 + " (" 
					+ FINVDETL3_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FINVDETL3_AMT+ " TEXT, " 
					+ FINVDETL3_ITEM_CODE+ " TEXT, " 
					+ FINVDETL3_QTY+ " TEXT, " 
					+ FINVDETL3_REF_NO+ " TEXT, " 
					+ FINVDETL3_SEQ_NO+ " TEXT, " 
					+ FINVDETL3_TAX_AMT+ " TEXT, " 
					+ FINVDETL3_TAX_COM_CODE+ " TEXT, " 
					+ FINVDETL3_TXN_DATE+ " TEXT); ";		


				
				/**
				 * ############################ FTranDet ################################ 
				 * 
				*/				
				public static final String TABLE_FTRANDET = "FTranDet";
				// table attributes
				public static final String FTRANDET_ID = "FTranDet_id";
				public static final String FTRANDET_REFNO = "RefNo";
				public static final String FTRANDET_TXNDATE = "TxnDate";
				public static final String FTRANDET_LOCCODE = "LocCode";
				public static final String FTRANDET_TXNTYPE = "TxnType";
				public static final String FTRANDET_SEQNO = "SeqNo";
				public static final String FTRANDET_ITEMCODE = "ItemCode";
				public static final String FTRANDET_QTY = "Qty";
				public static final String FTRANDET_AMT = "Amt";
				
				public static final String FTRANDET_CASEQTY = "CaseQty";
				public static final String FTRANDET_PICEQTY = "PiceQty";
				public static final String REMQTY = "remqty";
				
				
				//create String 
				private static final String CREATE_FTRANDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FTRANDET + " (" 
					+ FTRANDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FTRANDET_REFNO+ " TEXT, " 
					+ FTRANDET_TXNDATE+ " TEXT, " 
					+ FTRANDET_LOCCODE+ " TEXT, " 
					+ FTRANDET_TXNTYPE+ " TEXT, " 
					+ FTRANDET_SEQNO+ " TEXT, " 
					+ FTRANDET_ITEMCODE+ " TEXT, " 
					+ FTRANDET_QTY+ " TEXT, " 
					+ FTRANDET_AMT+ " TEXT,"
					+ FTRANDET_CASEQTY+ " TEXT,"
					+ FTRANDET_PICEQTY+ " TEXT,"
					+ REMQTY+ " TEXT); ";
				
				
				
				/**
				 * ############################ FTranHed ################################ 
				 * 
				*/		
				
				
				public static final String TABLE_FTRANHED = "FTranHed";
				// table attributes
				public static final String FTRANHED_ID = "FTranHed_id";
				public static final String FTRANHED_REFNO = "RefNo";
				public static final String FTRANHED_TXNDATE = "TxnDate";
				public static final String FTRANHED_MANUREF = "ManuRef";
				public static final String FTRANHED_COSTCODE = "CostCode";
				public static final String FTRANHED_REMARKS = "Remarks";
				public static final String FTRANHED_TXNTYPE = "TxnType";
				public static final String FTRANHED_TOTALAMT = "TotalAmt";
				public static final String FTRANHED_DELPERSN = "DelPerson";
				public static final String FTRANHED_DELADD1 = "DelAdd1";
				public static final String FTRANHED_DELADD2 = "DelAdd2";
				public static final String FTRANHED_DELADD3 = "DelAdd3";
				public static final String FTRANHED_VEHICALNO = "VehicalNo";
				public static final String FTRANHED_PRTCOPY = "PrtCopy";
				public static final String FTRANHED_GLPOST = "GlPost";
				public static final String FTRANHED_GLBATCH = "GlBatch";
				public static final String FTRANHED_ADDUSER = "AddUser";
				public static final String FTRANHED_ADDDATE = "AddDate";
				
				public static final String FTRANHED_ADDMACH = "AddMach";
				public static final String FTRANHED_DEALCODE = "DealCode";
				
				public static final String FTRANHED_LONGITUDE = "Longitude";
				public static final String FTRANHED_LATITUDE = "Latitude";
				public static final String FTRANHED_LOCFROM = "Locfrom";
				public static final String FTRANHED_LOCTO = "Locto";
				public static final String FTRANHED_IS_SYNCED = "issync";
				public static final String FTRANHED_ACTIVE_STATE = "ActiveState";

				
				
				
				//create String 
				private static final String CREATE_FTRANHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FTRANHED + " (" 
					+ FTRANHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FTRANHED_REFNO+ " TEXT, " 
					+ FTRANHED_TXNDATE+ " TEXT, " 
					+ FTRANHED_MANUREF+ " TEXT, " 
					+ FTRANHED_COSTCODE+ " TEXT, " 
					+ FTRANHED_REMARKS+ " TEXT, " 
					+ FTRANHED_TXNTYPE+ " TEXT, " 
					+ FTRANHED_TOTALAMT+ " TEXT, " 
					+ FTRANHED_DELPERSN+ " TEXT,"
					+ FTRANHED_DELADD1+ " TEXT,"
					+ FTRANHED_DELADD2+ " TEXT, " 
					+ FTRANHED_DELADD3+ " TEXT, " 
					+ FTRANHED_VEHICALNO+ " TEXT, " 
					+ FTRANHED_PRTCOPY+ " TEXT, " 
					+ FTRANHED_GLPOST+ " TEXT, " 
					+ FTRANHED_GLBATCH+ " TEXT, " 
					+ FTRANHED_ADDUSER+ " TEXT,"
					+ FTRANHED_ADDDATE+ " TEXT,"
					+ FTRANHED_ADDMACH+ " TEXT,"
					+ FTRANHED_DEALCODE+ " TEXT,"
					+ FTRANHED_LONGITUDE+ " TEXT,"
					+ FTRANHED_LATITUDE+ " TEXT,"
					+ FTRANHED_LOCFROM+ " TEXT,"
					+ FTRANHED_LOCTO+ " TEXT,"
					+ FTRANHED_IS_SYNCED+ " TEXT,"
					+ FTRANHED_ACTIVE_STATE+ " TEXT); ";
				
				
				
				
				/**
				 * ############################ FTranIss ################################ 
				 * 
				*/				
				
				
				public static final String TABLE_FTRANISS = "FTranIss";
				// table attributes
				public static final String FTRANISS_ID = "FTranHed_id";
				public static final String FTRANISS_REFNO = "RefNo";
				public static final String FTRANISS_TXNDATE = "TxnDate";
				public static final String FTRANISS_STKRECNO = "StkreCno";
				public static final String FTRANISS_STKRECDATE = "StkrecDate";
				public static final String FTRANISS_STKTXNNO = "StkTxnNo";
				public static final String FTRANISS_STKTXNDATE = "StkTxnDate";
				public static final String FTRANISS_STKTXNTYPE = "StkTxnType";
				public static final String FTRANISS_LOCCODE = "LocCode";
				public static final String FTRANISS_ITEMCODE = "ItemCode";
				public static final String FTRANISS_QTY = "Qty";
				public static final String FTRANISS_COSTPRICE = "CostPrice";
				public static final String FTRANISS_AMT = "Amt";
				public static final String FTRANISS_OTHCOST = "OthCost";
			
				
				
				//create String 
				private static final String CREATE_FTRANISS_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FTRANISS + " (" 
					+ FTRANISS_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FTRANISS_REFNO+ " TEXT, " 
					+ FTRANISS_TXNDATE+ " TEXT, " 
					+ FTRANISS_STKRECNO+ " TEXT, " 
					+ FTRANISS_STKRECDATE+ " TEXT, " 
					+ FTRANISS_STKTXNNO+ " TEXT, " 
					+ FTRANISS_STKTXNDATE+ " TEXT, " 
					+ FTRANISS_STKTXNTYPE+ " TEXT, " 
					+ FTRANISS_LOCCODE+ " TEXT,"
					+ FTRANISS_ITEMCODE+ " TEXT,"
					+ FTRANISS_QTY+ " TEXT, " 
					+ FTRANISS_COSTPRICE+ " TEXT, " 
					+ FTRANISS_AMT+ " TEXT, " 
					+ FTRANISS_OTHCOST+ " TEXT); ";		
				
				
				/**
				 * ############################ FDaynonprdHed ################################ 
				 * 
				*/		
				
				

				public static final String TABLE_NONPRDHED = "FDaynPrdHed";
				// table attributes
				public static final String NONPRDHED_ID = "FNonprdHed_id";
				public static final String NONPRDHED_REFNO = "RefNo";
				public static final String NONPRDHED_TXNDAET = "TxnDate";
				public static final String NONPRDHED_DEALCODE = "DealCode";
				public static final String NONPRDHED_REPCODE = "RepCode";
				public static final String NONPRDHED_REMARK = "Remarks";
				public static final String NONPRDHED_COSTCODE = "CostCode";
				public static final String NONPRDHED_ADDUSER = "AddUser";
				public static final String NONPRDHED_ADDDATE = "AddDate";
				public static final String NONPRDHED_ADDMACH = "AddMach";
				public static final String NONPRDHED_TRANSBATCH = "TranBatch";
				public static final String NONPRDHED_IS_SYNCED = "ISsync";
				public static final String NONPRDHED_ADDRESS = "Address";
	
			
				
				
				//create String 
				private static final String CREATE_TABLE_NONPRDHED = "CREATE  TABLE IF NOT EXISTS "+ TABLE_NONPRDHED + " (" 
					+ NONPRDHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ NONPRDHED_REFNO+ " TEXT, " 
					+ NONPRDHED_TXNDAET+ " TEXT, " 
					+ NONPRDHED_DEALCODE+ " TEXT, " 
					+ NONPRDHED_REPCODE+ " TEXT, " 
					+ NONPRDHED_REMARK+ " TEXT, " 
					+ NONPRDHED_COSTCODE+ " TEXT, " 
					+ NONPRDHED_ADDUSER+ " TEXT, " 
					+ NONPRDHED_ADDDATE+ " TEXT,"
					+ NONPRDHED_ADDMACH+ " TEXT,"
					+ NONPRDHED_TRANSBATCH+ " TEXT, " 
					+ NONPRDHED_IS_SYNCED+ " TEXT,"
					+ NONPRDHED_ADDRESS+ " TEXT); ";	

				
				
				/**
				 * ############################ FDaynonprdDet ################################ 
				 * 
				*/
				public static final String TABLE_NONPRDDET = "FDaynPrdDet";
				// table attributes
				public static final String NONPRDDET_ID = "FNonprdDet_id";
				public static final String NONPRDDET_REFNO = "RefNo";
				public static final String NONPRDDET_TXNDATE = "TxnDate";
				public static final String NONPRDDET_DEBCODE = "DebCode";
				public static final String NONPRDDET_REASON = "Reason";
				public static final String NONPRDDET_LONGITUDE = "Longitude";
				public static final String NONPRDDET_LATITUDE = "Latitude";
				public static final String NONPRDDET_REPCODE = "RepCode";
				public static final String NONPRDDET_IS_SYNCED = "ISsync";
	
			
				
				
				//create String 
				private static final String CREATE_TABLE_NONPRDDET = "CREATE  TABLE IF NOT EXISTS "+ TABLE_NONPRDDET + " (" 
					+ NONPRDDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ NONPRDDET_REFNO+ " TEXT, " 
					+ NONPRDDET_TXNDATE+ " TEXT, " 
					+ NONPRDDET_DEBCODE+ " TEXT, " 
					+ NONPRDDET_REASON+ " TEXT, " 
					+ NONPRDDET_LONGITUDE+ " TEXT, " 
					+ NONPRDDET_LATITUDE+ " TEXT, " 
					+ NONPRDDET_REPCODE+ " TEXT, " 
					+ NONPRDDET_IS_SYNCED+ " TEXT); ";
				
				
				
				/**
				 * ############################ FDamHed ################################ 
				 * 
				*/		
				
				
				public static final String TABLE_FDAMHED = "FDamHed";
				// table attributes
				public static final String FDAMHED_ID = "FDamHed_id";
				public static final String FDAMHED_REFNO = "RefNo";
				public static final String FDAMHED_TXNDATE = "TxnDate";
				public static final String FDAMHED_MANUREF = "ManuRef";
				public static final String FDAMHED_DEALCODE = "DealCode";
				public static final String FDAMHED_COSTCODE = "CostCode";
				public static final String FDAMHED_REMARKS = "Remarks";
				public static final String FDAMHED_TXNTYPE = "TxnType";
				public static final String FDAMHED_TOTALAMT = "TotalAmt";
				public static final String FDAMHED_REACODE = "ReaCode";
				public static final String FDAMHED_ITEMTYPE = "ItemType";
				public static final String FDAMHED_GLPOST = "GlPost";
				public static final String FDAMHED_GLBATCH = "GlBatch";
				public static final String FDAMHED_ADDUSER = "AddUser";
				public static final String FDAMHED_ADDDATE = "AddDate";
				
				public static final String FDAMHED_ADDMACH = "AddMach";
				
				
				public static final String FDAMHED_LOCFROM = "Locfrom";
				public static final String FDAMHED_LOCTO = "Locto";
				public static final String FDAMHED_IS_SYNCED = "issync";
				public static final String FDAMHED_ACTIVE_STATE = "ActiveState";

				
				
				
				//create String 
				private static final String CREATE_FDAMHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDAMHED + " (" 
					+ FDAMHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FDAMHED_REFNO+ " TEXT, " 
					+ FDAMHED_TXNDATE+ " TEXT, " 
					+ FDAMHED_MANUREF+ " TEXT, " 
					+ FDAMHED_COSTCODE+ " TEXT, " 
					+ FDAMHED_REMARKS+ " TEXT, " 
					+ FDAMHED_TXNTYPE+ " TEXT, " 
					+ FDAMHED_TOTALAMT+ " TEXT, "
					+ FDAMHED_REACODE+ " TEXT, "
					+ FDAMHED_ITEMTYPE+ " TEXT, "
					+ FDAMHED_GLPOST+ " TEXT, " 
					+ FDAMHED_GLBATCH+ " TEXT, " 
					+ FDAMHED_ADDUSER+ " TEXT,"
					+ FDAMHED_ADDDATE+ " TEXT,"
					+ FDAMHED_ADDMACH+ " TEXT,"
					+ FDAMHED_DEALCODE+ " TEXT,"
					+ FDAMHED_LOCFROM+ " TEXT,"
					+ FDAMHED_LOCTO+ " TEXT,"
					+ FDAMHED_IS_SYNCED+ " TEXT,"
					+ FDAMHED_ACTIVE_STATE+ " TEXT); ";
				
				
				/**
				 * ############################ FDamDet ################################ 
				 * 
				*/				
				public static final String TABLE_FDAMDET = "FDamDet";
				// table attributes
				public static final String FDAMDET_ID = "FTranDet_id";
				public static final String FDAMDET_REFNO = "RefNo";
				public static final String FDAMDET_TXNDATE = "TxnDate";
				public static final String FDAMDET_LOCCODE = "LocCode";
				public static final String FDAMDET_TXNTYPE = "TxnType";
				public static final String FDAMDET_SEQNO = "SeqNo";
				public static final String FDAMDET_ITEMCODE = "ItemCode";
				public static final String FDAMDET_REACODE = "ReaCode";
				public static final String FDAMDET_REANAME = "ReaName";
				public static final String FDAMDET_QTY = "Qty";
				public static final String FDAMDET_AMT = "Amt";
				public static final String FDAMDET_CASEQTY = "CaseQty";
				public static final String FDAMDET_PICEQTY = "PiceQty";
				public static final String REMQTYDAM = "remqty";
				
				
				
				//create String 
				private static final String CREATE_FDAMDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDAMDET + " (" 
					+ FDAMDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FDAMDET_REFNO+ " TEXT, " 
					+ FDAMDET_TXNDATE+ " TEXT, " 
					+ FDAMDET_LOCCODE+ " TEXT, " 
					+ FDAMDET_TXNTYPE+ " TEXT, " 
					+ FDAMDET_SEQNO+ " TEXT, " 
					+ FDAMDET_ITEMCODE+ " TEXT, " 
					+ FDAMDET_REACODE+ " TEXT, "
					+ FDAMDET_REANAME+ " TEXT, "
					+ FDAMDET_QTY+ " TEXT, " 
					+ FDAMDET_AMT+ " TEXT,"
					+ FDAMDET_CASEQTY+ " TEXT,"
					+ FDAMDET_PICEQTY+ " TEXT,"
					+ REMQTYDAM+ " TEXT); ";
				
				
				/**
				 * ############################ FDayExpHed ################################ 
				 * 
				*/		
				
				
				public static final String TABLE_FDAYEXPHED = "FDayExpHed";
				// table attributes
				public static final String FDAYEXPHED_ID = "FDayExpHed_id";
				public static final String FDAYEXPHED_REFNO = "RefNo";
				public static final String FDAYEXPHED_TXNDATE = "TxnDate";
				public static final String FDAYEXPHED_REPNAME = "RepName";
				public static final String FDAYEXPHED_DEALCODE= "DealCode";
				public static final String FDAYEXPHED_COSTCODE = "CostCode";
				public static final String FDAYEXPHED_REPCODE = "RepCode";
				public static final String FDAYEXPHED_REMARKS = "Remarks";
				public static final String FDAYEXPHED_AREACODE = "AreaCode";
				public static final String FDAYEXPHED_ADDUSER = "AddUser";
				public static final String FDAYEXPHED_ADDDATE = "AddDate";
				public static final String FDAYEXPHED_ADDMATCH = "AddMach";
				public static final String FDAYEXPHED_LONGITUDE = "Longitude";
				public static final String FDAYEXPHED_LATITUDE = "Latitude";
				public static final String FDAYEXPHED_ISSYNC = "issync";
				public static final String FDAYEXPHED_ACTIVESTATE = "ActiveState";
				public static final String FDAYEXPHED_TOTAMT = "TotAmt";
				public static final String FDAYEXPHED_ADDRESS = "Address";

				
				
				
				//create String 
				private static final String CREATE_FDAYEXPHED_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDAYEXPHED + " (" 
					+ FDAYEXPHED_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FDAYEXPHED_REFNO+ " TEXT, " 
					+ FDAYEXPHED_TXNDATE+ " TEXT, " 
					+ FDAYEXPHED_REPNAME+ " TEXT, " 
					+ FDAYEXPHED_DEALCODE+ " TEXT, " 
					+ FDAYEXPHED_COSTCODE+ " TEXT, " 
					+ FDAYEXPHED_REPCODE+ " TEXT, " 
					+ FDAYEXPHED_REMARKS+ " TEXT, "
					+ FDAYEXPHED_AREACODE+ " TEXT, "
					+ FDAYEXPHED_ADDUSER+ " TEXT, "
					+ FDAYEXPHED_ADDDATE+ " TEXT, " 
					+ FDAYEXPHED_ADDMATCH+ " TEXT, " 
					+ FDAYEXPHED_LONGITUDE+ " TEXT,"
					+ FDAYEXPHED_LATITUDE+ " TEXT,"
					+ FDAYEXPHED_ISSYNC+ " TEXT,"
					+ FDAYEXPHED_ACTIVESTATE+ " TEXT); ";
				
				/**
				 * ############################ FDayExpDet ################################ 
				 * 
				*/				
				public static final String TABLE_FDAYEXPDET = "FDayExpDet";
				// table attributes
				public static final String FDAYEXPDET_ID = "FDayExpDet_id";
				public static final String FDAYEXPDET_REFNO = "RefNo";
				public static final String FDAYEXPDET_TXNDATE = "TxnDate";;
				public static final String FDAYEXPDET_SEQNO = "SeqNo";
				public static final String FDAYEXPDET_EXPCODE = "ExpCode";
				public static final String FDAYEXPDET_AMT = "Amt";
				
				
				
				//create String 
				private static final String CREATE_FDAYEXPDET_TABLE = "CREATE  TABLE IF NOT EXISTS "+ TABLE_FDAYEXPDET + " (" 
					+ FDAYEXPDET_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, " 
					+ FDAYEXPDET_REFNO+ " TEXT, " 
					+ FDAYEXPDET_TXNDATE+ " TEXT, "  
					+ FDAYEXPDET_SEQNO+ " TEXT, "
					+ FDAYEXPDET_EXPCODE+ " TEXT, "
					+ FDAYEXPDET_AMT+ " TEXT); ";
				
				
//--------------------------------------------------------------------------------------------------------------

	@Override
	public void onCreate(SQLiteDatabase arg0) {
		
		arg0.execSQL(CREATE_SERVER_DB_TABLE);
		arg0.execSQL(CREATE_FDEBTOR_TABLE);
		arg0.execSQL(CREATE_FCONTROL_TABLE);
		arg0.execSQL(CREATE_FCOMPANYSETTING_TABLE);
		arg0.execSQL(CREATE_FINVDET_TABLE);
		arg0.execSQL(CREATE_FROUTE_TABLE);
		arg0.execSQL(CREATE_FBANK_TABLE);
		arg0.execSQL(CREATE_FREASON_TABLE);
		arg0.execSQL(CREATE_FEXPENSE_TABLE);
		arg0.execSQL(CREATE_FTOWN_TABLE);
		arg0.execSQL(CREATE_FTRGCAPUL_TABLE);
		arg0.execSQL(CREATE_FTYPE_TABLE);	
		arg0.execSQL(CREATE_FSUBBRAND_TABLE);
		arg0.execSQL(CREATE_FGROUP_TABLE);
		arg0.execSQL(CREATE_FSKU_TABLE);
		arg0.execSQL(CREATE_FBRAND_TABLE);
		arg0.execSQL(CREATE_FORDHED_TABLE);
		arg0.execSQL(CREATE_FORDDET_TABLE);
		arg0.execSQL(CREATE_FCOMPANYBRANCH_TABLE);
		arg0.execSQL(CREATE_FSALREP_TABLE);
		arg0.execSQL(CREATE_FDDBNOTE_TABLE);
		arg0.execSQL(CREATE_FFREEDEB_TABLE);
		arg0.execSQL(CREATE_FFREEDET_TABLE);
		arg0.execSQL(CREATE_FFREEHED_TABLE);
		arg0.execSQL(CREATE_FFREESLAB_TABLE);
		arg0.execSQL(CREATE_FFREEITEM_TABLE);
		arg0.execSQL(CREATE_FITEM_TABLE);
		arg0.execSQL(CREATE_FITEMLOC_TABLE);
		arg0.execSQL(CREATE_FITEMPRI_TABLE);
		arg0.execSQL(CREATE_FAREA_TABLE);
		arg0.execSQL(CREATE_FLOCATIONS_TABLE);
		arg0.execSQL(CREATE_FDEALER_TABLE);
		arg0.execSQL(CREATE_FFREEMSLAB_TABLE);
		arg0.execSQL(CREATE_FMERCH_TABLE);
		arg0.execSQL(CREATE_FROUTEDET_TABLE);
		arg0.execSQL(CREATE_FDISCVHED_TABLE);
		arg0.execSQL(CREATE_FDISCVDET_TABLE);
		arg0.execSQL(CREATE_FDISCVDEB_TABLE);
		arg0.execSQL(CREATE_FDISCHED_TABLE);
		arg0.execSQL(CREATE_FDISCDET_TABLE);
		arg0.execSQL(CREATE_FDISCDEB_TABLE);
		arg0.execSQL(CREATE_FDISCSLAB_TABLE);
		arg0.execSQL(CREATE_FITENRHED_TABLE);
		arg0.execSQL(CREATE_FITENRDET_TABLE);
		arg0.execSQL(CREATE_FITEDEBDET_TABLE);
		arg0.execSQL(CREATE_FINVHEDL3_TABLE);
		arg0.execSQL(CREATE_FINVDETL3_TABLE);
		arg0.execSQL(CREATE_FINVHED_TABLE);
		arg0.execSQL(CREATE_FTRANDET_TABLE);
		arg0.execSQL(CREATE_FTRANHED_TABLE);
		arg0.execSQL(CREATE_FTRANISS_TABLE);
		arg0.execSQL(CREATE_TABLE_NONPRDHED);
		arg0.execSQL(CREATE_TABLE_NONPRDDET);
		arg0.execSQL(CREATE_FDAMHED_TABLE);
		arg0.execSQL(CREATE_FDAMDET_TABLE);
		arg0.execSQL(CREATE_FDAYEXPHED_TABLE);
		arg0.execSQL(CREATE_FDAYEXPDET_TABLE);
		
		
		
		
	}

//--------------------------------------------------------------------------------------------------------------
	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		
//		try{
//			arg0.execSQL("ALTER TABLE "+TABLE_FSALREP+" ADD COLUMN "+FSALREP_PASSWORD+" TEXT DEFAULT 0");
//				
//		}catch(SQLiteException e){
//			Log.v("SQLiteException - "+TABLE_FSALREP, e.toString());
//		}
//		

//		try{
//			arg0.execSQL("ALTER TABLE "+TABLE_FDEALER+" ADD COLUMN "+FDEALER_PREFIX+" TEXT DEFAULT 0");
//				
//		}catch(SQLiteException e){
//			Log.v("SQLiteException - "+TABLE_FDEALER, e.toString());
//		}
		
		//FORDHED  
//		try{
//			arg0.execSQL("ALTER TABLE "+TABLE_FORDHED+" ADD COLUMN "+FORDHED_ADD_DATE+" TEXT DEFAULT 0");
//				
//		}catch(SQLiteException e){
//			Log.v("SQLiteException - "+TABLE_FORDHED, e.toString());
//		}
//		
//		try{
//			arg0.execSQL("ALTER TABLE "+TABLE_FORDHED+" ADD COLUMN "+FORDHED_APP_DATE+" TEXT DEFAULT 0");
//				
//		}catch(SQLiteException e){
//			Log.v("SQLiteException - "+TABLE_FORDHED, e.toString());
//		}
//		
//		try{
//		arg0.execSQL("ALTER TABLE "+TABLE_FDAMDET+" ADD COLUMN "+FDAMHED_REACODE+" TEXT DEFAULT 0");
//			
//	}catch(SQLiteException e){
//		Log.v("SQLiteException - "+TABLE_FDAMDET, e.toString());
//	}
		
//		try{
//		arg0.execSQL("ALTER TABLE "+TABLE_FDAYEXPHED+" ADD COLUMN "+FDAYEXPHED_ADDRESS+" TEXT DEFAULT 0");
//			
//	}catch(SQLiteException e){
//		Log.v("SQLiteException - "+TABLE_FDAYEXPHED, e.toString());
//	}
		
		this.onCreate(arg0);

	}

}
